Quick troubleshooting of slow responsiveness on an IIS–SQL Server app
On the very first set of requests – monitor the incoming requests (by running a SQL profiler trace). In conjunction, on the IIS server, you may need to run a few performance counters to monitor the HTTP requests. If all you care about is the total processing time of the HTTP requests, that info is readily available from the IIS log (no perf counters needed). This is available in the time-taken field in IIS 6.0 and IIS 7.0 HTTP logs.
Leave a Reply