How many concurrent users does MSDE 2000 support?

I am a little bit confused about this issue. The MSDE 2000 tech notes tells about a limit of 5 workloads. Does it means 5 concurrent users? How many concurrent users can be connected in a single database? Can I have more than 5 users on client applicatio
ns whithout degradation ?
> limit of 5 workloads. Does it means 5 concurrent users?
No, it means 5 users performing work at the exact same time. You can have a
boatload of idle connections, but if they all start doing work, you're
eventually going to see the governor start to throttle performance.

> How many concurrent users can be connected in a single database?
How fast can your car go? Depends on plenty of things: weather, road
conditions, speed limit, presence of state troopers, tire pressure, your own
nerves, abilities, reflexes, etc. etc. Impossible to answer for you, you
will need to test it yourself.
How many users can be connected to a database? Depends on plenty of things:
application code, what they're actually doing, hardware, bandwidth, what
else the server is spending resources on, disk I/O, etc. etc. Impossible to
answer for you, you will need to test it yourself.

> Can I have more than 5 users on client applications whithout degradation ?
Possibly. See above.
http://www.aspfaq.com/
(Reverse address to reply.)
|||In addition to Aaron's information, have a look at these topics in the
lastest version of the SQL Server 2000 Books Online:
http://msdn.microsoft.com/library/de...asp?frame=true
http://msdn.microsoft.com/library/de...asp?frame=true
http://msdn.microsoft.com/library/de...asp?frame=true
http://msdn.microsoft.com/library/de...asp?frame=true
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights