PASS Summit 2009: Post-Conference Sessions (Enterprise Database Administration and Deployment)
Return to Session Listings
Practical Performance Monitoring and Troubleshooting
Andrew Kelly (Solid Quality Mentors)
This seminar will cover all the details on how to capture and analyze the most useful and practical statistics for database and system performance. After attending this seminar, you will be able to easily decipher the metrics that lead to identifying system bottlenecks. A good portion of the seminar will consist of demos highlighting the code used to capture and analyze the metrics data. You can then take this code home and use it immediately on your own systems. This seminar does not have a specific query-tuning focus, but it will help you identify poorly performing queries and many other issues such as missing/duplicate indexes, file and wait stats, disk issues, and so on. The workshop will also discuss the new Data Performance Warehouse in SQL Server 2008.
Watch 24 Hours of PASS Session Recording
Q&A with Andrew
Q: What do you think is the most overlooked or underutilized statistic for performance tuning and investigation?
A: Without a doubt, it’s wait statistics. Properly analyzed, wait stats can tell you more in a short amount of time than any other statistic or counter. When it comes to performance issues, too many DBAs these days tend to shy away from using wait stats because they’re not the best documented or understood of topics. But every DBA should make a conscious effort to learn more about them and to use the information they provide on a regular basis.
Read the rest of Andrew's conversation with PASS here.
About the Speaker
Andrew J. Kelly, a SQL Server MVP since 2001, is the practice manager for performance and scalability at Solid Quality Mentors. With 20 years’ experience in relational databases and application development, Andrew specializes in performance, scalability, and maintainability of large-scale SQL Servers. He also writes for leading SQL Server publications, is an active blogger, and regularly speaks at conferences and user groups.
See the other sessions Andrew is presenting at PASS Summit 2009 here.
Register now for PASS Summit 2009!