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?
Best Answer
Places to start... SQL server trace filtered to the web server host, you should be able to see connections come in and get released or re-used. And also how long the queries are taking. IIS Daignotstic pack use logman and log parser to see what is going on in IIS. Has your application pool only got one thread? What if you give it say 10.