SQL PASS: All the Magic Knobs

Posted byCindy Gross | She-Her | Befriending DragonsPosted inSmall Bites of Big DataTags:, , ,

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

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.

Leave a Reply

%d bloggers like this: