Re: MSDE2000 Rel A & Internet hosted App

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 17:22:32 +0100

hi James,
"James Monza" <anonymous@discussions.microsoft.com> ha scritto nel messaggio
news:A3D52152-BC70-4EFC-9B77-EF7D47062052@microsoft.com...
> Dear Microsoft Community,
>
> We have a Win2003 Enterprise server with MSDE200 Rel A installed along
with a business objects reporting software which allows users to view
reports against a sql database hosted on a different machine. The reporting
app references a sql odbc to attache to the sql server and database.
>
> We expect about a 50-100 concurrent connections to view the reports using
the reporting app and the msde.
>
> Is this the correct approach? I am concerned in that MSDE product specs
on the website outline that this is ideal for upto 25 concurrent sessions.
>
> Thank you.
> James.

it really depends on the activity the concurrent users will perfrom against
the MSDE instance...
it's not a problem of concurrent sessions, but of concurrent worlkloads,
which is limited to 5 users workloads + 3 system...
please have a look at
http://www.microsoft.com/sql/msde/techinfo/workloadgov.asp for more detailed
info about this matter.. 

-- 
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm        http://italy.mvps.org
DbaMgr2k ver 0.6.0  -  DbaMgr ver 0.52.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Relevant Pages

  • Re: 3vl 2vl and NULL
    ... reporting, MV end-users were either churning out reports and ad hoc ... MV-database-independent applications as often as they do in the SQL ... where I cannot leave MV behind unless I can find a better data model. ... screen to be identical to the logical data model of the database. ...
    (comp.databases.theory)
  • Re: Long Discussion Re Relational
    ... And you don't fiddle with SQL statements and data, ... early to mid-70's IBM product that because of that gathered a ... LIST THE CUSTOMER FILE SHOWING ME ACCOUNT.NO NAME TOTALLING THE ... de-facto reporting language that everybody was waiting for.... ...
    (comp.databases.pick)
  • Re: SSRS und ReportViewer
    ... Reporting Services, daher geht's von RDLC nach RDL eher automatisch, als umgekehrt. ... Schon mal dran gedacht, den SQL Server 2005 Express Advanced Edition zu installieren, und damit dessen Reporting Engine. ...
    (microsoft.public.de.german.entwickler.dotnet.vb)
  • [ANN] CrunchyFrog 0.4.0
    ... CrunchyFrog is a SQL client mainly for the GNOME desktop. ... massimiliano.bini for reporting and testing). ...
    (comp.lang.python.announce)
  • Re: Reporting Services Clustering ?
    ... So I would have to upgrade to SQL 2005 Enterprise as I cannot upgrade ... strictly to Reporting Sevices Enterprise? ... You are correct, Reporting Services Standard ... SQL clustering is MSCS based and is a failover technology. ...
    (microsoft.public.sqlserver.clustering)
Quantcast