Enable: Asp.net connection pool monitoring with performance monitor
- by BlackHawkDesign
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