Post reply

Procedure cache, Plan cache, Buffer cache

  • April 7, 2009 at 5:43 pm

    #208047

    hi can anyone tell me diference between

    procedure cache- i know plans here plans for stored proc's are stored

    plan cache- query plans are stored

    data cache- i dont know this one?

    buffer pool-

    buffer manager

    thanks,

  • April 8, 2009 at 1:32 am

    #974049

    The procedure cache and the plan cache are the same thing. Two different names. It was called the procedure cache in SQL 2000 and before because mainly it would contain plans of procedures. In 2005 and higher, adhoc SQL is cached the same way as procedures and it's now called the plan cache.

    Data cache is where SQL caches pages from tables or indexes to avoid having to go to disk to fech them.

    Buffer pool is the collective name for all of the paged memory that SQL has. It contains the plan cache, the data cache and several other smaller caches

    Buffer manager manages the buffer pool, size, ageing of entries, etc.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply