Wednesday, March 28, 2012

Information about MSDE

I've a question...
How many user can I supporto in a webapplication with MSDE?
Thanks
Hi,
There is a great thread called "MSDE limits" below that has the following
info.
Cheers
Scott
"MSDE 2000 LIMITS
- MAX SIZE IS 2GB
- 2 CPUS
- NUMBER OF USERS. The limit is not based upon concurrent connections. It is
based upon concurrent "workloads". There is a big difference between this
and concurrent connections. When the system needs to execute more than 8
concurrent query plans, it inserts a delay in each logical page access. For
small queries, this can have a minor effect. For larger table scans, this
can have a large effect. Use DBCC CONCURRENCYVIOLATION to investigate if any
delays have been inserted and how often. 20 users can be happy with a single
instance of the MSDE but depends on application workload. The 2G database
size limit seems to impact most people before the query governor does.
NOTE: actually allows 32,767 connections to an instance of the database.
Further reading on "The SQL Server 2000 Workload Governor" can be sound
here.
http://msdn.microsoft.com/library/?u...asp?frame=true"
|||Thanks for informations

No comments:

Post a Comment