Proc-Cache

Tag: proc-cache

SQL PASS Day 1: To Free or Not To Free the Proc Cache?

SQL PASS Day 1: To Free or Not To Free the Proc Cache?

on November 4, 2009

Category: performance-tuning

Tags: execution-plan , proc-cache , procedure-cache , sqlpass

Yesterday was day 1 of SQL PASS 2009. I am attending a variety of sessions on execution plans this year, and along the way I heard three very different opinions yesterday on managing the procedure cache in presentations.

Continue reading

Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.