December 9, 2009 at 5:19 am
Hi,
What is the maximum number of users managed by SQL 2005 EXPRESS ?
5 as MSDE ? Or there's not a limit ?
Thank you
December 9, 2009 at 7:08 am
I don't believe that there is a concurrent user limit in 2005 Express like there was in MSDE. Your main limiter now is that you are restricted to 1GB RAM and 4GB max database size.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 9, 2009 at 8:27 am
Very thank you
December 12, 2009 at 6:19 pm
Jack is correct here. The actual concurrent worker limit would be dependent on what platform you are running on. A 32bit installation would only have 256 workers, and a 64bit installation would have 512 workers. I would expect that you would have excess performance problems from the lack of memory and scheduler yield issues before you could get 256 concurrent workers in SQL Express, but it is a possibility.
SQL Express can only utilize one processor, but it can use every core on that processor, so if you had a quad core machine, you could have parallelism occur for a commonly called, complex query, that could eat up the available workers in a 32 bit Express instance quickly. It would depend on the number of RelOp nodes the query had. If it had 3 nodes and ran at DOP 4, it would consume 12/13 workers per concurrent execution.
You would see extensive IO pressure/memory pressure before you got there though.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply