The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Event Display
Meeting Detail

Tue, Feb 02 2016 11:00 (UTC-06:00) Central Time (US & Canada)

Performance Tuning Methodology as Gail Sees It


Performance Tuning Methodology as Gail Sees It

Ever sat down in front of a badly performing SQL Server and wondered where to start in fixing it? In this session I’ll take you through the methodology that I use on my client’s servers to identify, diagnose and fix all manner of performance problems. We'll look at perfmon counters and wait stats, extended events and DMVs and come up with a list of the most critical things that need fixing.

Gail is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail holds a Microsoft Certified Master certification for SQL Server 2008 and is a Data Platform MVP. She's a frequent poster on the SQLServerCentral forums, a Pluralsight author, writes articles for both and, and has spoken at SQLSaturdays, SQL Bits and at the PASS Community Summit. Gail has been responsible for extending the lifespan of many an application by performance-tuning their databases as well as providing technical guidance on all things SQL Server related.

Back to Top