From time to time, something happens to our website that makes it slow and unresponsive. Inevitably, this happens at like 3 AM, on a day when all the devs have gone to bed early.
Are there any good tools for taking a "snapshot" of the state of the webserver and the db server at that moment? I want to get an email with a full report -- what was the CPU doing? any process thrashing disks? ASP.NET worker process queue out of control? long-running db queries?
This is for a Windows Server 2008 R2 box running IIS, and a SQL Server 2008 R2 instance.
Basically, I want to be able to see enough stuff that I have some hope of figuring out what was making things slow.