Why are we Waiting.. Part 2
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.
We now take this into the next version, join us for the journey where we will be using the latest in Waits analysis using Extended Events and XQuery to shine the spotlight on this fascinating area
Neil Hambly is a SQL veteran with over 15 years’ expertise in SQL Server from Version 6.5 through to the very latest 2012 edition. Neil has held numerous DB roles at major organizations such as BBC, ABN AMRO, ACCENTURE, alongside a number of smaller companies, with prior roles as both a DBA ,Developer & Architect,
He is a SQL Server Technology Evangelist @ Northdoor PLC www.northdoor.co.uk
The Leader of both the PASS London and Virtual Professional Development Chapters
Neil is often found presenting @ international and domestic SQL events