Control over procedure cache We are still waiting for more control over procedure cache.  Adam Machanic wrote up this blog post highlighting a Connect item which he opened in 2007.  It is currently closed as ''won't fix'' but it's been shown time and time again that in some cases we need this extra knob. #293188 : Amount of RAM for ...