Analyzing File and Wait Statistics (DBA)

Presenter: Andrew J. Kelly

Session Details

The ability to collect and analyze File & Wait statistics in terms of performance directly from within SQL Server is often underutilized. The information that can be gleaned from these statistics has increased dramatically with each new release of SQL Server, and SQL Server 2008 has added a bunch more wait types, including the new Preemptive ones. We'll cover each of the most common waits and discuss what you need to do to reduce them. Stop wondering what is causing the bottlenecks in your system, and start addressing them.

About the Speakers

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 with 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.