Tracking Waits with Extended Events in SQL Server 2008
Starting with SQL 2008, there is a new feature called Extended Events which every DBA and Developer should become familiar with. Extended Events allow us to monitor and troubleshoot in ways not possible with previous methods while incurring less overhead on the server. Come see how we can utilize this new feature to track waits all the way down to the query level with minimal overhead. We will also cover the common waits found in most SQL Server instances and discuss ways to avoid or address them.
Solid Quality Mentors
Andrew J. Kelly is a Partner & Mentor with Solid Quality Mentors and lives in Myrtle Beach, South Carolina. He has over 20 years experience with relational databases and application development but his main focus now is SQL Server. In addition to general SQL Server training and Mentoring he specializes in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year at many conferences and user groups and has been a SQL Server MVP since 2001
Tampa General Hospital
Sr. Database Administrator
Jonathan Kehayias is a Senior Database Administrator and SQL Server MVP.
Register Now for PASS Summit 2010!