Sunday, March 25, 2012

Does SQL Express have a Simultaneous Connections Limit?

I have used MSDE in the past & it had a limit on the number of simultaneous
connections per the Microsoft paid support folks. I found various articles
on SQL Express with the limitations but nothing referencing the number of
connections. Has anyone already found this out?"BCW" <nospam@.cfl.rr.com> wrote in message
news:uiyafD9PGHA.2912@.tk2msftngp13.phx.gbl...
>I have used MSDE in the past & it had a limit on the number of
>simultaneous
> connections per the Microsoft paid support folks. I found various
> articles
> on SQL Express with the limitations but nothing referencing the number of
> connections. Has anyone already found this out?
There is no limitation on connections in MSDE or in SQL Express. MSDE was
optimized for a "typical" load of upto 25 users I believe but this wasn't a
hard limit it was just a potential throttle on scalability. AFAIK there is
no such constraint on SQL Express. If you check out the feature comparison
however you'll see that Express supports only a single processor and 1GB
RAM. So those are the limits you have to work within:
http://www.microsoft.com/sql/prodin...e-features.mspx
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

No comments:

Post a Comment