• 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

Bonus: Storytelling Time

  1. Home
  2. SQL Server Training Classes by Brent Ozar
  3. Mastering Server Tuning with Wait Stats
  4. Bonus: Storytelling Time

During class, we went offtopic a few times during the breaks, so I’m sharing the videos here because they’re amusing. I leave these as open to the public because it gives you a feel for what the class breaks are like, and the quality of the audio & video of my classes.

Should you use the new OPTIMIZE_FOR_SEQUENTIAL_KEY option, and where do options like this come from?

About that time I helped our company pick out a new SAN:

  • 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.3 Lab 3: Mixed Workload
  • 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

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

  • Consulting
  • Training
  • Monitoring
  • Scripts
  • Blog

Save your cart?

x