By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,743 Members | 804 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,743 IT Pros & Developers. It's quick & easy.

Connection Pool

P: n/a
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!!!!

Nov 18 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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!!!!

Nov 18 '05 #2

P: n/a
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!!!!


Nov 18 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.