Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-17 : 13:46:33
|
| PRADEEP writes "Can Any One can tell me ,How many users can connect to a Microsoft SqL Server 2000 Desktop Edition installed in a centralized place.ie. how many concurrent users it can handle at the same time.regardspradeep" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-06-17 : 18:33:07
|
| It is more the number of concurrent queries that affects it more than the number of connections. MSDE has a query governor that will degrade query performance (on purpose) when 5 or more concurrent queries are runnig - it is quite feasible to support a much large number of users but it depnds on the activity of your application.HTHJasper Smith |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-06-17 : 19:20:08
|
| Look up DBCC CONCURRENCYVIOLATION in the Books Online. That will tell you how many times you've hit the query govenor limits.I'm my experience, about 50 users is feasible with MSDE. Depending on yoru application and the number of queries each users runs, you may be able to get more or less users. I'd not expect more than 100 users though.Michael |
|
|
|
|
|
|
MSDE