Cindy Gross: SQL Server + Big Data

Cindy Gross - SQL Server and Big Data Troubleshooting + Tips

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: Memory Trimming: A significant part of sql server process memory has been paged out.

    I have written about this topic before (in my old SQLCommunity blog) but I still see lots of questions about it. So here is a simplified explanation of this memory trimming issue that is common with SQL Server on Windows 2003. On Windows 2003 you may occasionally see memory trimming messages in...
Page 1 of 1 (2 items)