Using perfmon to monitor database problems with applications

At work we have had a major problem with one of our web applications. It was erroring frequently for one client, but not for others. Viewing the application log in event viewer, numerous database timeouts were listed, but what was causing this? After much deliberation, we suddenly recalled that perfmon may shine more of a light on this. This post gives instructions on how to use perfmon. Once set up and counters were running, I logged into the site and mointored perfmon whilst doing a few things. Suddenly connections rose dramatically as I began using a certain bit of fucntionality. Now all thats left to do is to fix it, but I think this will be the easier part of the job…

Advertisements