What would cause my request timer to report such long request execution times?

Question

I am using a modified version of the code here. The difference is that I log it to a database and only if it is longer that 5000ms. The results have me worried. Several pages will occasionally log an execution time of minutes. Never will they consistently under perform, but according to log table, it is happening often enough that I need to get to the bottom of it.

So I'm throwing it out here to see what kind of ideas the community has. Perhaps it's due to app restarts? recompiles? Maybe some subtle flaw in the httpmodule that would cause it to misreport the time?

Answer 1

Check the system event log to see if there are any correlated events. Looking for service restarts or service crashes, etc.

You're going to need to log more information until you can pinpoint the issue. Hopefully its only happening on a particular page so you can isolate it that way... Don't fall into the trap of trying to fix the problem before you really understand it.

Answer 2

Try keeping a close watch on the locks on your database, it could be a database locking issue, as that has happened to me and caused very similar symptoms.

Answer 3

Run your application through a profiler to see which methods are taking up the most processing time.