Delta Force (A Month of Activity Monitoring, Part 26 of 30)

re: Delta Force (A Month of Activity Monitoring, Part 26 of 30)

Igor Marchenko — Thu, 28 Apr 2011 21:23:33 GMT

Adam,

First of all kudos for your series! I learned a lot about powerful functionality of sp_WhoISActive. I used to sample CPU, reads, writes per interval manually (I had a script for that). sp_WhoISActive will certainly be a replacement for homegrown script I used.

Thanks again,

Igor

Who is Active's Hidden Gems (A Month of Activity Monitoring, Part 28 of 30)

Adam Machanic — Fri, 29 Apr 2011 01:03:44 GMT

This post is part 28 of a 30-part series about the Who is Active stored procedure. A new post will run

Twenty Nine Days of Activity Monitoring (A Month of Activity Monitoring, Part 30 of 30)

Adam Machanic — Sat, 30 Apr 2011 15:45:23 GMT

This post is part 30 of a 30-part series about the Who is Active stored procedure. A new post will run

re: Delta Force (A Month of Activity Monitoring, Part 26 of 30)

Ethan Murray — Sat, 08 Sep 2012 11:02:56 GMT

I've been looking for something like delta_mode for months. I run big reporting-centric databases full of long-running ad hoc queries, and I often need to get in and see why CPU is running hot, and who wrote the bad query. Nothing else I've tried has been so convenient and useful.