Number of concurrent users

Hello,

There was a 5 concurrent user limitation in MSDE (the version prior to SQL Express). Does that same limitation exist with SQL Express 2005?

Thanks.

Hi Val,

First off, there was not actually a 5 concurrent user limitation in MSDE, this was a myth. Check out Euan Garden's blog describing the true functionality of the MSDE workload governer if you're interested in the history of all this: http://blogs.msdn.com/euanga/archive/2006/03/09/545576.aspx.

As for SQL Express, there is no limit to the number of users; the workload governer has been completely removed. We do limit you to a single CPU, 1 GB of memory and 4 GB of user data per database.

Regards,

Mike Wachal
SQL Express team

|||Mike,

Thanks a lot for your reply and for the link to the Blog. Very interesting.