• For example on one of my machines I have max memory set at 26,624 MB, which is my buffer size, the plan cache is an additional 4,408 MB. I don't believe there is a setting to force the plan cache to be smaller, only the buffer cache, you really shouldn't be running anything else on your sql box anyway.