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 FastContinue reading “SQL PASS: All the Magic Knobs”
Tag Archives: LPIM
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 your SQL ServerContinue reading “Memory Trimming: A significant part of sql server process memory has been paged out.”
