25 MSDE Connections

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
hi Tom,
Tom Celica wrote:
> 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/?u...asp?frame=true
for all available info about the built in Workload Governor..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://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