Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

SQL Server: Performance Troubleshooting Using Wait Statistics

via Pluralsight

Overview

Learn how to begin troubleshooting SQL Server performance problems, applicable for developers and DBAs from SQL Server 2005 onwards

Where do you start looking when trying to diagnose a performance problem with SQL Server? The answer is to use wait statistics! This course will introduce you to the powerful 'waits and queues' performance tuning methodology. You'll learn how SQL Server's thread scheduling system works, what wait statistics are and how to use them, what more advanced synchronization mechanisms like latches and spinlocks are, and a wealth of detail about common performance issues and how to diagnose and solve them. The course is perfect for developers and DBAs who have been struggling to figure out how to start troubleshooting performance problems with SQL Server. The information in the course applies to all versions from SQL Server 2005 onwards.

Syllabus

  • Introduction 15mins
  • SQL Server Threading Model 35mins
  • Waits 43mins
  • Latches and Spinlocks 33mins
  • Troubleshooting Patterns 124mins
  • Summary 20mins

Taught by

Paul Randal

Reviews

4.9 rating at Pluralsight based on 475 ratings

Start your review of SQL Server: Performance Troubleshooting Using Wait Statistics

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.