Using Wait Statistics

Wait Stats are the best kept secret in SQL performance tuning. This deep dive into wait stats will bring you up to speed on everything that you need to know about wait stats in SQL 2005/8.

Starting with the SQL execution model intternals we will cover all the common wait types, how they work, interpreting them, and how you can use them for performance tuning. We will also be covering key improvements in SQL 2008 and a few of the popular tools used by SQL consultants to analyse them.
Presented by Bob Duffy at SQLBits VI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Bob_Duffy.jpg
    Bob Duffy is a SQL Server MVP, currently working as a Database and Solution Architect in Dublin, Ireland. He has over 19 years experience in the database sector, with MCA, MCM and Maestro certification.
    http://blogs.prodata.ie/author/Bob.aspx http://blogs.prodata.ie/syndication.axd
  • Video
    The video is not available to view online.