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 Shaw is a database specialist from Johannesburg, South Africa, specializing in performance tuning and database optimization.
Gail works for Entelect, a medium-sized custom software development house based in Johannesburg.
Gail is a frequent poster on the SQLServerCentral.com forums and writes for Simple-Talk. She is an MVP for SQL Server and holds the Microsoft Certified Master certification for SQL Server.