Your Performance Tuning Check List
summary
Checklist of concrete fixes: set Windows power plan to High Performance and disable non‑SQL services; keep SQL Server on current CUs/SPs for optimizer fixes; set max server memory (leave OS/headroom), enable VM memory reservation and consider Lock Pages; put tempdb on fast disks with multiple equal‑sized files and use trace flags or 2016+ defaults; enable Instant File Initialization; set sensible MAXDOP and Cost Threshold (start ~half cores, cost 35–50); turn on RCSI for blocking relief; keep VLF count <300; update stats (TF2371) and watch key lookups (add included columns).
AI-written summary · about
chapters (17)
- 0:00Intro
- 1:33Best Practices
- 5:17Patching
- 7:51Memory
- 17:11MaxDP
- 20:45Instant File initialization
- 22:30Instant File initialization example
- 23:39Blocking
- 24:05Snapshot Isolation
- 26:38Virtual Log Files
- 29:45Make Friends
- 31:54VM Inspector
- 36:41Compression
- 41:02Statistics
- 44:45Indexes
- 48:56Execution Plans
- 55:20References
related talks
54mYour Performance Tuning Check List
43mPerformance Tuning, Getting the Biggest Bang for Your Buck
47mArchitecting for High Performance SQL Server on Virtual Machines
01h 00m7 Tips to Performance Tuning, Optimization, and Everything
51mPerformance Tuning Azure SQL Database
26mThe five-step guide to SQL tuning- 47mArchitecting for High Performance SQL Server on Virtual Machines
44mImproving Performance with Intelligent Query Processing