The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.
Tue, Mar 07 2017 11:00 (UTC-06:00) Central Time (US & Canada)
Performance Troubleshooting Using Wait Statistics
One of the first things you should check when investigating performance issues are wait statistics - as these can often point you in the direction for further analysis. Unfortunately many people misinterpret what SQL Server is telling them and jump to conclusions about how to solve the problem - what is often called 'knee-jerk performance tuning'. In this session, you will learn what waits are, how to analyze them, and potential solutions to common problem patterns.
Paul’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world. He spent 9 years working on the SQL Server team, writing DBCC CHECKDB, and ultimately responsible for the entire Storage Engine. In 2007 Paul left Microsoft to co-own and run SQLskills.com, and has been a SQL Server MVP ever since. When he's not tweeting, blogging, or helping someone recover from a disaster, he's likely to be underwater somewhere in the world with his wife, Kimberly L. Tripp. Full bio at http://www.sqlskills.com/about/paul-s-randal/
JOIN PASS then add our Virtual Chapter to your list
Please join our chapter by creating a user account. This can be accomplished by clicking here. All registered users will be emailed detailed instructions prior to each meeting. Thanks!
Present to our Chapter
* Send us an abstract, and your biography to DBAFundamentals@sqlpass.org
* Put Speaker Request in the Subject
* Be patient and we will get back to you. We get a lot of emails.
Meetings At A Glance
Event Registration Link
SQL Tiger Team
In-Memory OLTP. What it can do for me?
Deadlocking for Mere Mortals
Dr. DMV’s Troubleshooting Toolkit