I'm a C# developer, but I'm running in a system management issue here.
I'm 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: Ensure Proper SQL Server Connection Pooling.
Basically it explains stuff about connection pools and how you can monitor the application pool with performance monitor.
So I logged in to the ASP.NET server(The SQL database is hosted on a different server) which hosts the web site. I started performance monitor, but when I want to select 'Current # pooled and nonpooled connections', I have no instance to select. Therefore I can't add it.
How can I create/supply an instance so I can monitor the connection pool?