var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
sysprocedures table stores parased query plans and it follows MRU-LRU algorithms. My question here is, Is there any limit (ie memory specific)
to store query plans in sysprocedures?
Yes, the procedure cache size will determine when, if ever, a procedure is kicked out of the cache. Also note that recompiles (or dynamic SQL) will require recompilation which causes high cache turnover.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors