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.
AllTheMagicKnobs.pptx
Like this:
Like Loading...
Published by Cindy Gross | She-Her | Befriending Dragons
I am a Workplace Thrival Coach, a Race+Gender Equity Adaptive Leader, an ex-techie, & the founder of Befriending Dragons. I lead & coach with empathy & an intersectional social equity perspective so you can unleash the change & impact you want to have in the world. I am a chaos dragon, injecting just enough disruption around me to open new perspectives and new harmonies. I seek wise justice.
View more posts