SQL Server DBA Scripts: How to Find Slow SQL Server Queries

SQL Server database administrators need to be able to quickly find out what queries and stored procedures are running slow.  Microsoft includes sp_who and sp_who2 in SQL Server 2005 and 2008, but there’s a much better tool, and it’s completely free.

In this five minute tutorial video, I explain how to use sp_WhoIsActive from Adam Machanic (Blog – @AdamMachanic).  Sorry about the audio – I’ve ordered a new microphone and it hasn’t arrived yet.

Where to Download sp_WhoIsActive

• You can download sp_WhoIsActive for free
• Read Adam’s posts about sp_WhoIsActive
• If you like it, tell Adam by leaving a comment on his blog
• How to collect sp_WhoIsActive results into a table over time for troubleshooting history

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts