Performance tuning & query optimization
Slow queries, blocking, runaway CPU, missing or bloated indexes — diagnosed and fixed with measurable before/after numbers.
- Wait-stat and query store analysis to find the real bottleneck
- Execution plan review and rewrite of the worst offenders
- Index design: missing, redundant, and overweight indexes
- tempdb, parallelism, memory grants, and parameter-sniffing fixes
- Before/after benchmarks so the impact is provable
When you need this
Reports that used to finish in seconds now take minutes. The application feels sluggish under load. CPU sits at 90% with no obvious culprit. Users complain about timeouts. You suspect indexes are part of the story but don’t know where to start.
What’s included
A focused engagement built around your actual workload:
- Baseline. Capture wait stats, top queries by CPU/duration/reads, and Query Store snapshots so we know where time is going today.
- Diagnose. Walk the worst queries from execution plan to root cause — index design, statistics, parameter sniffing, blocking, tempdb contention, memory grants, parallelism, or schema choices.
- Fix. Rewrite queries, redesign indexes, tune configuration, and apply the changes in a controlled way (always with a back-out path).
- Prove. Re-run the baseline and hand you a short report with measurable before/after numbers, plus a runbook so the team can repeat the analysis.
Typical engagement
A first pass usually takes one to two weeks part-time. Many clients then keep me on retainer for a few hours a month to keep things healthy as the workload grows.
Deliverables
- Tuning report with root causes, the changes applied, and benchmarks
- Updated indexes, queries, and configuration in a reviewable script
- Query Store / monitoring dashboards you can keep using after I leave
Sound like a fit?
First 30 minutes are free.