Enable: Asp.net connection pool monitoring with performance monitor

Posted by BlackHawkDesign on Server Fault See other posts from Server Fault or by BlackHawkDesign
Published on 2012-08-30T09:03:34Z Indexed on 2012/08/30 9:40 UTC
Read the original article Hit count: 404

If this question is at the wrong forum, be free to tell me. I'm a c# developer, but I'm running in a system management issue here.

Intro:

Im suspecting that an asp.net application is having some issues with the connection pool and that the pool is flooding from time to time. So to make sure, I want to monitor the connection pool. After some searching I found this article : http://blog.idera.com/sql-server/performance-and-monitoring/ensure-proper-sql-server-connection-pooling-2/ Basicly it explains stuff about connection pools and how you can monitor the application pool with performance monitor.

The problem:

So I logged in to the asp.net server(The sql database is hosted on a different server) which hosts the website. Started performance monitor. But when I want to select 'Current # pooled and nonpooled connections', I have no instance to select. There fore I can't add it.

Question

How can I create/supply an instance so I can monitor the connection pool?

Thanks in advance

BHD

© Server Fault or respective owner

Related posts about Performance

Related posts about monitoring