Your Performance Tuning Check List

on YouTube ↗54m

" summary

Checklist of concrete changes: set OS/VM to High Performance for an observed 30% CPU gain (verify with CPU‑Z), disable unused services (SSIS/SSRS), apply relevant CUs (2016 SP1, 2016 CU8, 2017 CU5 fixes), enable trace flag 4199 at database scope, size and set max server memory using John Morehouse scripts, reserve VM memory / consider lock pages only for VMs, configure tempdb on fastest disks with one file per core up to eight matched sizes (TF 1117/1118 pre‑2016), grant IFI permission, enable RCSI and remove NOLOCK hints.

AI-written summary · about

" related talks

• 57mYour Performance Tuning Check ListMonica Rathbun · Women Data Summit 2021
• 43mPerformance Tuning, Getting the Biggest Bang for Your BuckMonica Rathbun · SQL Server Virtual Conference 2021
• 47mArchitecting for High Performance SQL Server on Virtual MachinesAnthony Nocentino · SQLBits 2019
• 01h 00m7 Tips to Performance Tuning, Optimization, and EverythingPinal Dave · 24 Hours of PASS: Summit Preview 2015
• 47mArchitecting for High Performance SQL Server on Virtual MachinesAnthony Nocentino · SQLBits 2022
• 44mImproving Performance with Intelligent Query ProcessingJohn Morehouse · SQL Server Virtual Conference 2021
• 51mThe Diabolical Developer's Guide to Perfomance TuningMartijn Verburg · Devoxx Belgium 2017
• 58mTroubleshooting CPU Performance Issue for SQL DevelopersPinal Dave · Great Indian Developer Summit 2015