Wait watchers - Gain Performance Increases Fast!
We're all told to watch our weight and to exercise more, so to flip this on its head I will be showing you exercises that you can do to watch your waits. You could even eat a Danish pastry while watching if you wish (Danish pastry’s not provided).
In this session you will learn all about SQL Server’s wait statistics, these are statistics the database engine stores about the resources it is waiting on. Armed with this information you as a SQL Server professional
can make better informed decisions on which areas of your environment to tune to greater effect.
After attending this session you will be able to know where to find, interpret and use this information to tie down problem areas in your SQL Server estate not to fix that problem query, but improve overall
performance for all of your users.
Sorry, there are no downloads available for this session.
Richard Douglas is a Systems Consultant and SQL Server Evangelist for Dell Software where he specialises in providing SQL Server solutions and system health checks to organisations across the EMEA region. Richard is the founder and organiser of the Maidenhead SQL Server User Group and has spoken at several PASS events including the PASS Summit, SQL Rally's and SQL Saturdays. Richard also regularly presents webinars for Dell Software and PASS Virtual Chapters on various SQL Server related topics and was a technical reviewer on two SQL Server 2012 books.
Richard can be contacted via Twitter @SQLRich or on his blog http://SQL.RichardDouglas.co.uk
The video is not available to view online.