Question (paraphrased): “Conor, does changing the max server memory settings always empty the plan cache on SQL 2005 and 2008?” Answer: yes, this is what happens and what is supposed to happen. One of the inputs to the optimizer is the max server memory, and it is used in the costing functions to determine which plan gets chosen during optimization. Changing this setting could imply that other plans are now better. As such, the plan cache is emptied and plans are compiled…(read more)
Conor vs. Max Server Memory
Posted by Code Monkey
on September 30, 2011
Comments are closed.