monitoring the size of an SQL Server connection pool

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?

Answer

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

Attribution
Source : Link , Question Author : Shiraz Bhaiji , Answer Author : Jason Horner

Leave a Comment