• Log In
  • Contact Brent
Product has been added to your cart.
  • Consulting
    • Performance Tuning
    • Remote DBA Services
    • Upgrades and Migrations
    • Consultant Toolkit
  • Training
    • Conferences
    • My Videos and Downloads
    • My Account
    • Private SQL Server Training
    • Training FAQ
    • Watch Brent Streaming Live
  • Monitoring
  • Scripts
    • sp_Blitz – free health check
    • sp_BlitzCache – find queries to tune
    • sp_BlitzFirst – instant performance check
    • sp_BlitzIndex – design the right indexes
    • sp_BlitzWho – what’s happening right now
    • PasteThePlan – share query plans
  • Blog
    • T-SQL
    • Execution Plans
    • Indexing
    • Videos
    • Architecture
    • Backup and Recovery
    • Cloud Computing
    • Development
    • First Responder Kit
    • High Availability
    • Humor
    • Locking, Blocking, and Isolation Levels
    • Parameter Sniffing
    • Production Database Administration
    • Professional Development
    • SQL ConstantCare
In real life, you don’t just have “a CPU workload” or “an IO workload” – you have a hot mess, and that’s exactly what you get in this lab. You’ve got queries exhibiting a variety of anti-patterns. Start by solving the most critical one, then revisit your waits, plan cache, and indexes to see what...
To access this incredible, amazing content, you gotta get Mastering Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.
  • 0.1 Prerequisites Before the Class
  • 0.2 Download the Slides and Scripts
  • 1.1 How to Measure Your SQL Server
  • 1.2 How to Fix PAGEIOLATCH Waits
  • 1.3 Lab 1: Fixing PAGEIOLATCH Waits
  • 1.4 How to Fix CPU Waits (SOS_SCHEDULER_YIELD)
  • 1.5 Lab 2: CPU-Intensive Workload
  • 2.1 How to Fix Parallelism Waits (CXPACKET, CXCONSUMER, and LATCH_EX)
  • 2.2 Plan Caching and Parameterization
  • 2.4 How to Fix Blocking Waits (LCK%)
  • 2.5 Lab 4 Setup: Planning the Work
  • 3.1 How to Fix Worker Thread Waits (THREADPOOL)
  • 3.2 How to Fix Query Memory Waits (RESOURCE_SEMAPHORE)
  • 3.3 How to Fix Hardware-Sounding Waits (WRITELOG, HADR_SYNC_COMMIT, ASYNC_NETWORK_IO)
  • 3.4 Lab 5 Setup: Architecture Changes
  • 3.5 How to Triage Performance Emergencies
  • 3.6 Lab 6 Setup: Emergency Triage
  • Bonus: Abnormal Parallelism
  • Bonus: Storytelling Time

© Brent Ozar Unlimited®. All Rights Reserved.
Privacy Policy – Terms and Conditions

  • Consulting
  • Training
  • Monitoring
  • Scripts
  • Blog

Save your cart?

x