SQLBits 2011
Why are we Waiting..
Not to be confused with the Rugby / Football ditties, but actually an in-depth look @ "Waits" Side of the well-known "Waits & Queues" methodology
With focus in this session on interpreting the information in the (DMV) sys.dm_os_wait_stats
An in-depth look @ "Waits" Side of the well-known "Waits & Queues" methodology With focus in this session on interpreting the information in the (DMV) sys.dm_os_wait_stats and which of these “Waits “ are experiencing excessive waits and those you can safely ignore. Using an established methodology like that of “Waits & Queues” to find and eliminate those pesky performance hurdles will only be successful if you can interpret those wait values correctly.
This session requires the attendees to be familiar with many areas of the SQL Server stack and such is aimed @ those experienced DBAs / Developers / Architects with performance tuning duties.