SQL PASS: All the Magic Knobs
SQL PASS 2011 DBA-319-C #SQLPASS
All the Magic Knobs - Low Effort, High Return Tuning
Key points covered:
- Power Savings = High Performance
- Smart Virtualization
- Enough Hardware
- Control other apps, filter drivers
- Optimize for ad hoc workloads = ON
- Compression = ON
- Set LPIM + Max Server Memory
- Pre-size files, avoid shrink and autogrow
- Fast Tempdb
- Proper Maintenance
My presentation from 10/13/11 is attached.