We are trying to track down a performance issue.
One theory we have is that we are running out of connections in the connection pool.
Is there a way to monitor the size of a connection pool?
SnapOverflow
We are trying to track down a performance issue.
One theory we have is that we are running out of connections in the connection pool.
Is there a way to monitor the size of a connection pool?
Have a look at these performance counters:
http://msdn.microsoft.com/en-us/library/ms254503.aspx
Some of these counters require a change to the app.config file
Not really. This is a client side thing (the pool), not a server side thing. Except with leaky cionnections (open until gc kicks in) I have never seen that exhausted. I am note sure where the default limit is - I think around 200 or so.