Wednesday, September 22, 2010

Find Slow Running Queries - great T-SQL script find!

If you've ever used sp_who and/or sp_who2, you'll appreciate the insight this free script Adam Machanic wrote and shared, sp_whoisactive. Way more useful than the out of the box scripts.

There is a great video tutorial and link to the free download here: brentozar, and even a way to save the results over time to a table.

No comments: