Elephant Wishes (SQL Server and Data Ramblings)

I wish I could remember everything...

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.
Posted by Lara Rasner at 3:30 PM No comments:
Labels: sp_whoisactive, t-sql slow running queries
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Search This Blog

Blog Archive

  • ►  2020 (1)
    • ►  January 2020 (1)
  • ►  2015 (2)
    • ►  May 2015 (1)
    • ►  April 2015 (1)
  • ►  2014 (4)
    • ►  September 2014 (1)
    • ►  July 2014 (1)
    • ►  May 2014 (1)
    • ►  March 2014 (1)
  • ►  2013 (5)
    • ►  December 2013 (2)
    • ►  July 2013 (1)
    • ►  June 2013 (2)
  • ►  2012 (3)
    • ►  August 2012 (1)
    • ►  July 2012 (1)
    • ►  March 2012 (1)
  • ►  2011 (5)
    • ►  November 2011 (1)
    • ►  July 2011 (1)
    • ►  June 2011 (1)
    • ►  March 2011 (1)
    • ►  January 2011 (1)
  • ▼  2010 (9)
    • ►  November 2010 (2)
    • ►  October 2010 (1)
    • ▼  September 2010 (1)
      • Find Slow Running Queries - great T-SQL script find!
    • ►  July 2010 (1)
    • ►  June 2010 (4)
  • ►  2009 (5)
    • ►  October 2009 (1)
    • ►  July 2009 (1)
    • ►  April 2009 (3)
  • ►  2008 (7)
    • ►  June 2008 (1)
    • ►  April 2008 (6)

About Me

My photo
Lara Rasner
Carlsbad, California, United States
while ( ! ( succeed = try() ) )
View my complete profile
Simple theme. Powered by Blogger.