Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Location
    Hyderabad
    Posts
    2

    Thumbs up Unanswered: sysprocedures table behaviour

    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?

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    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.
    Thanks,

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •