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.
Sorry, there are no downloads available for this session.
Bob Duffy is a SQL Server MVP, currently working as a Database and Solution Architect in Dublin, Ireland. He has over 20 years experience in the database sector, with MCA, MCM and Maestro certification.
The video is not available to view online.