On a Win2003 server, a site running Classic ASP (not asp.net) is having performance problems.
How can I monitor the performance of the connection pool?
The backend SQL Server database (on another server) is nowhere near breaking a sweat, and the server itself is also running fine.
I monitor "Request Execution Time" and "Requests Queued" - and when the problems appear, bot these counters shoot up rapidly - site gets slow an unresponsive - and then falls back to normal after 20-30 seconds (normal = 0 requests queued).
Now my gut feeling is telling me there must be an issue with connection pooling, since the error I get on the site is.
So again - how can I monitor if this is being caused by problems in the connection pooling?