how to determinethe number of used connections in connection pool

Question

0.00/5 (No votes)

See more:

Hi All,

In my connectionstring Pooling is enabled and set in range from 0 to 40 connections.
Still sometimes I have a email from my system that tells me the connectionpool is out of resources.

Is there a way to determin if how many connections in the pool are used and what the accompanying SqlCommand object is. In this way I can determine which db calls are finished but are left open (and find the bug I created myself)

Posted 30-Jul-12 22:25pm

Herman<T>.Instance

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Answer 1 · 2012-07-30T22:54:00

Solution 1

It is likely that you can monitor the pool from code also, but these are easier to use:
http://www.c-sharpcorner.com/blogs/1713/monitoring-connection-pooling.aspx[^]
http://www.wduffy.co.uk/blog/monitoring-database-connections/[^]
http://msdn.microsoft.com/en-us/library/aa175863(v=sql.80).aspx[^]

Posted 30-Jul-12 22:54pm

Zoltán Zörgő

Comments

Herman<T>.Instance 31-Jul-12 5:08am

thanks for the link. had seem them already. I really mis a code example on how to check this in Code.

Zoltán Zörgő 31-Jul-12 5:32am

These are low level parameters you want to check. You can use PerformanceCounter class to access the performance counters, and you could start from this article to access SQL server profiling information.