SQL Server Performance Forum – Threads Archive
SQL SERVER EXPRESS CONCURRENT USER LIMITATION
HI ALL,<br /><br />I WANT TO UPLOAD AN WEBSITE WHICH CONSIST OF LOGIN AND PASSWORDS FOR MORE THAN 300 USERS. I AM USING SQL SERVER EXPRESS. I WANTED TO KNOW WHETHER THERE IS ANY CONCURRENT USERS PROBLEM WITH SQL SERVER EXPRESS 2005 AS THERE IS PROBLEM IN MSDE VERSION. IF YES HOW MANY USERS.<br /><br />PLEASE HELP ME. THANKS IN ADVANCE [<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br /><br />AMIT<br />
http://msdn2.microsoft.com/en-us/library/ms345154.aspx
quote:
The SQL engine supports 1 CPU, 1 GB RAM, and a 4 GB database size. This mechanism permits easy differentiation from other SQL Server 2005 editions by having well defined cut-off points. Otherwise, there is no workload throttle and the engine performs as in other editions. There is no hard-coded limit to the number of users that can attach to SQL Server Express but their CPU and memory limits impose practical limits on the number of users that can achieve acceptable response times from a SQL Server Express database.
The SQL engine supports 1 CPU, 1 GB RAM, and a 4 GB database size. This mechanism permits easy differentiation from other SQL Server 2005 editions by having well defined cut-off points. Otherwise, there is no workload throttle and the engine performs as in other editions. There is no hard-coded limit to the number of users that can attach to SQL Server Express but their CPU and memory limits impose practical limits on the number of users that can achieve acceptable response times from a SQL Server Express database.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>