Hi,
To add to Rick
Performance Counters for Connection Pooling
The .NET Framework Data Provider for SQL Server adds several performance
counters that enable you to fine-tune connection pooling characteristics,
detect intermittent problems related to failed connection attempts, and
detect problems related to timed-out requests to your SQL Server.
The following table lists the connection pooling counters that can be
accessed in Performance Monitor under the ".NET CLR Data" performance
object.
Counter
Description
SqlClient: Current # of pooled and non pooled connections
Current number of connections, pooled or not.
SqlClient: Current # pooled connections
Current number of connections in all pools associated with the process.
SqlClient: Current # connection pools
Current number of pools associated with the process.
SqlClient: Peak # pooled connections
The highest number of connections in all pools since the process started.
Note: this counter is only available when associated with a specific process
instance.
The _Global instance will always return 0.
SqlClient: Total # failed connects The total number of connection open
attempts that have failed for any reason.
Source::
http://msdn.microsoft.com/library/de...taprovider.asp
Regards
Ashish M Bhonkiya
"Rick Strahl [MVP]" <ri********@hotmail.com> wrote in message
news:uM**************@TK2MSFTNGP09.phx.gbl...
Hi Jim,
You can use performance counters to see the SQL connection pool, which is
probably the easiest way to see this. You'll want to look at open
connections as well as the .Net sql counters for this (can't recall
offhand what the names are - use Server Explorer or PerfMon to check them out).
+++ Rick ---
--
Rick Strahl
West Wind Technologies
http://www.west-wind.com/
http://www.west-wind.com/weblog/
----------------------------------
Making waves on the Web
"Jim Heavey" <Ji*******@nospam.com> wrote in message
news:Xn*********************************@207.46.24 8.16... How do I set up a Connection Pool?
How can I look on the server and see how many connections are being used
by my application? I am pretty sure that my application must be leaving
connections open, because I begin to receive error message indicating
that the system can not open a connection and I should check my connection
pool, with me being the only one on the server, this should not really be a
problem. I am not sure why I do not receive the same error message
while testing on my own machine, but I am guessing that somehow or another
those connections must be being closed by the system some how.
Your assistance would be greatly appreciated!!!!