25 MSDE Connections

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom Celica - 13 Jul 2005 03:30 GMT

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
What is the definition of a "connection"? For example, if I create a
connection pool of 5 connections in an application, does that count as 5
against the 25?

-Thanks
-Tom

Reply to this Message

Andrea Montanari - 13 Jul 2005 11:32 GMT

hi Tom,

> In the MSDE Edition of Sql Server 2000 there is a limit of 25
> connections. What is the definition of a "connection"? For
> example, if I create a connection pool of 5 connections in an
> application, does that count as 5 against the 25?

there's not such a limit of "25 connection"... this magic number is just a
guess about the probably supported load of an MSDE instance.. and it fo
course is influenced by your architectural design, both within the db and
the app...
please have a look at
http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.asp
?frame=true
for all available info about the built in Workload Governor..

Signature

Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Reply to this Message