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
Subscribe to:
Post Comments (Atom)
Posts
0 comments:
Post a Comment