Re: SQL Express Connection String Limit
- From: "William Vaughn \(MVP\)" <billva@xxxxxxxxxxxxxxx>
- Date: Tue, 10 Feb 2009 13:05:00 -0800
Not really. The number of connections the server can managed is around 32,000 IIRC (if not more) but you'll exhaust the server's ability to service that many connections long before you reach the limit. SQL Express places no limit on the number of connections--just on the amount of system resources that can be applied to the threads they start. Most heavily used servers (ASP.NET architectures) typically service no more than a couple dozen connections at a time. However, this is not to say that only 24 users can connect--it means that at any point in time there are only a couple dozen clients actually doing work.
What's your concern?
--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com http://betav.com/blog/billva
____________________________________________________________________________________________
"Piyush Trivedi" <trivedi.piyush@xxxxxxxxxxxxxxx> wrote in message news:3F65393F-2907-4E10-81FF-CBC1DFE38799@xxxxxxxxxxxxxxxx
Hi,.
Is there any limit on number of connection on Sql Express 2008.
If yes then how many?
Thanks
- References:
- SQL Express Connection String Limit
- From: Piyush Trivedi
- SQL Express Connection String Limit
- Prev by Date: SQL Express Connection String Limit
- Next by Date: SQL Express slow when connecting from client on network.
- Previous by thread: SQL Express Connection String Limit
- Next by thread: SQL Express slow when connecting from client on network.
- Index(es):
Relevant Pages
|
