MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server: Performance Troubleshooting Using Wait Statistics

Course Summary

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

  • +

    Course Syllabus

    - 15m 9s

    —Introduction 1m 47s
    —Where to Start Troubleshooting? 2m 0s
    —Doctor, Doctor... My Knee Hurts! 2m 14s
    —Is the Symptom the Root Cause? 2m 38s
    —Interpreting the Data 2m 33s
    —Demo: Explaining the Workload Mechanism 2m 30s
    —Course Structure 1m 27s
    SQL Server Threading Model
    - 35m 10s

    —Introduction 1m 22s
    —What are Threads? 2m 7s
    —Parallelism 2m 6s
    —Parallel Threads Example 1m 6s
    —Controlling Parallelism 2m 6s
    —Thread Scheduling 1m 47s
    —Components of a Scheduler 0m 53s
    —Schedulers in SQL Server 1m 52s
    —Demo: sys.dm_os_schedulers 2m 8s
    —Thread States 1m 22s
    —Transition from RUNNING to SUSPENDED 0m 51s
    —The Waiter List 1m 22s
    —Special Case: Quantum Exhaustion 1m 43s
    —Transition from SUSPENDED to RUNNABLE 1m 23s
    —The Runnable Queue 1m 31s
    —Special Case: Resource Governor 2m 16s
    —Resource Governor Example 2m 1s
    —Transition from RUNNABLE to RUNNING 0m 47s
    —Putting It All Together 1m 31s
    —Demo: Examining Threads on Schedulers 3m 19s
    —Summary 1m 37s
    - 43m 18s
    Latches and Spinlocks
    - 33m 12s
    Troubleshooting Patterns
    - 2h 4m
    - 20m 54s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url