Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
how to configure connection pooling
0 views
Skip to first unread message
Lance
Mar 3, 2004, 5:02:11 AM3/3/04
to
Hi,
Is there a way to control the connection pools using SQL Server 2000? I
know how to alter the connection string to do
this(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguid
e/html/cpconconnectionpoolingforsqlservernetdataprovider.asp), but I am
looking for a setting in SQL Server that allows me ultimate control over all
connections to the DB. eg: I'd like all connection pools to timeout after
5min of inactivity, set the maximum pool size, etc. I am assuming that there
is some part of the GUI that allows this, or maybe even some (ugh) registry
editing! ;-)
Is there a way to control the connection pools using SQL Server 2000? I
know how to alter the connection string to do
this(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguid
e/html/cpconconnectionpoolingforsqlservernetdataprovider.asp), but I am
looking for a setting in SQL Server that allows me ultimate control over all
connections to the DB. eg: I'd like all connection pools to timeout after
5min of inactivity, set the maximum pool size, etc. I am assuming that there
is some part of the GUI that allows this, or maybe even some (ugh) registry
editing! ;-)
Thanks,
Lance
Jasper Smith
Mar 3, 2004, 7:49:37 AM3/3/04
to
This is all controlled on the client side. I'm not aware of anything that
can be configured within SQL Server itself that would affect this in the way
you want.
can be configured within SQL Server itself that would affect this in the way
you want.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Lance" <lancestuff27[nospam]@hotmail.com> wrote in message
news:104bba8...@corp.supernews.com...
0 new messages