five connection limit

30 Dec 2005 4:10 PM

Igor Solodovnikov

Hi!

Everybody know that MSDE (based on SQL Server 2000) has five-connection
limit after which its performance degrades. Do SQL server 2005 Express
edition also has five-connection limit? Or this limit was dropped?

30 Dec 2005 4:20 PM

Mike Epprecht (SQL MVP)

Hi

No connection limit in Express though a performance throttle, but it is
limited to use only 1 CPU, 1GB RAM and a database can have a maximum data
size of 4GB.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: m***@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

Show quote

"Igor Solodovnikov" <IgorSolodovni***@discussions.microsoft.com> wrote in
message news:op.s2ltu9n6n8ihmu@iw2k.helpmicro.local...
> Hi!
>
> Everybody know that MSDE (based on SQL Server 2000) has five-connection
> limit after which its performance degrades. Do SQL server 2005 Express
> edition also has five-connection limit? Or this limit was dropped?

30 Dec 2005 4:21 PM

Dan Guzman

The limit was removed in SQL 2005 Express. See
http://msdn2.microsoft.com/en-us/library/ms165672.aspx.

--
Happy Holidays

Dan Guzman
SQL Server MVP

Show quote

"Igor Solodovnikov" <IgorSolodovni***@discussions.microsoft.com> wrote in
message news:op.s2ltu9n6n8ihmu@iw2k.helpmicro.local...
> Hi!
>
> Everybody know that MSDE (based on SQL Server 2000) has five-connection
> limit after which its performance degrades. Do SQL server 2005 Express
> edition also has five-connection limit? Or this limit was dropped?