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.
Read more: Brent Ozar
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.
Read more: Brent Ozar