How to Monitor Wait Stats

• Imke Cronje

  SSCarpal Tunnel

  Points: 4826

  More actions

  April 5, 2012 at 2:05 am

  #258720

  Hi All,

  I need to monitor the wait stats of a particular query or process running against a SQL server instance.

  Does anyone perhaps have any suggestions what I can use?

  Regards

  IC

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  April 5, 2012 at 2:17 am

  #1469350

  This blog should help:

  http://www.sqlskills.com/BLOGS/PAUL/post/Capturing-wait-stats-for-a-single-operation.aspx

  -- Gianluca Sartori

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  April 6, 2012 at 9:06 am

  #1470148

  http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&ved=0CDAQFjAB&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F4%2F7%2Fa%2F47a548b9-249e-484c-abd7-29f31282b04d%2FPerformance_Tuning_Waits_Queues.doc&ei=HwZ_T5mVG5Ki8gT09Z3UBw&usg=AFQjCNFRIebSlMLnry8gH99CQklhdmokJw

  and search web for track_waitstats_2005

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service