I am researching this memory setting and trying to gather as much info as possible. I want to be sure that my sql min/max memory settings are adjusted appropriately for this change. Also, how will this play out with my large paging file that has a dedicated physical disk?
My total used memory on the (SQL only) box is at 99% and SQL uses 92%.
Win Server 2008 2008 R2 Enterprise
Memory - 144GB
Pagefile - 300gb
Pagefile local disk - 418gb
SQL Server 2008 Enterprise
SQL min server memory 0 MB
SQL max server memory 143872 MB
Use AWE = no
Lock pages in memory
This security setting determines which accounts can use a process to keep data in physical memory, which prevents the system from paging the data to virtual memory on disk. Exercising this privilege could significantly affect system performance by decreasing the amount of available random access memory (RAM).
Want to be sure that I am getting the most out of my hardware - Would appreciate any advice...