Query Optimization · Cohort
Parallelism Guardrails
When CXPACKET storms help and when they hurt—degree of parallelism choices without turning knobs blindly.
- Duration
- 2 weeks
- Skill focus
- Advanced
- Platform lens
- SQL Server
- Tuition (informational)
- ₩550,000
Overview
Parallelism tuning is often misunderstood. This course grounds decisions in waits, scheduler pressure, and predictable throughput tests. You leave with guardrail settings and a decision log template.
What is included
- Wait map labs
- Template for documenting MAXDOP experiments
- Office hour on NUMA myths vs realities
Outcomes
- Propose MAXDOP and CTFP tweaks with a measurement table
- Identify queries that should stay serial by design
Primary coach
Hana Sato
Former platform engineer who still ships patches to open-source query engines on weekends.
FAQ
Linux SQL Server?
Most labs run on Windows containers; Linux notes are provided as addenda.
Azure SQL?
Platform-specific auto-tuning interactions are summarized but not exhaustively tested.
What is not promised?
We do not guarantee specific throughput numbers—only sound measurement practice.
Experience notes
-
Mixed format: long quote on one slide, short bullets elsewhere—kept me awake in a good way.
Tuition is informational on this static preview. Enrollment teams confirm availability, tax treatment, and any employer procurement paperwork steps. See Returns & Refunds for eligibility framing.