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.
Bob Duffy is one of a select group of Microsoft Certified Architects for SQL Server (aka SQL Ranger) around the globe. He has worked with SQL Server since 1997, and been designing database solutions ob varuous platforms for over 18 years. Bob has involved in more than 250 projects. Recently Bob was awarded MVP in SQL Server for 2009.
Currently Bob is helping customers in Ireland with enterprise SQL Design, Consolidation, Performance Tuning and Business Intelligence at the Prodata SQL Centre of Excellence in Dublin. Previously Bob spent three years with Microsoft Consulting Services specialising in SQL Server and Business Intelligence platforms.
Bob has spoken at many events including Technet and MSDN, The Irish Java Technology Conference, The SQL 2008 Technical Launch (Dublin, Belfast, Cork, Galway), the SQL Ireland Users Group, MTUG (Microsoft Technology Users Group), the Irish SQL Academy programme and Epicenter. Bob is also on the working group for the new SQL 2008 Masters exams