Post reply

Memory Outside of the Buffer Pool

  • February 3, 2014 at 12:13 am

    #303676

    Hi All

    I understand that SQL Server's plan cache is memory taken from inside the buffer pool (Memory allocated by the Max Memory setting in SQL).

    I have seen articles and posts that indicates that the Plan Cache is taken from outside of the buffer pool, is this correct?

    Please confirm my understanding.

    Thanks

  • February 3, 2014 at 12:32 am

    #1685401

    SQLSACT (2/3/2014)

    I understand that SQL Server's plan cache is memory taken from outside of the buffer pool (Memory allocated by the Max Memory setting in SQL).

    No, the plan cache is part of the buffer pool.

    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

  • February 3, 2014 at 1:08 am

    #1685403

    GilaMonster (2/3/2014)

    SQLSACT (2/3/2014)

    I understand that SQL Server's plan cache is memory taken from outside of the buffer pool (Memory allocated by the Max Memory setting in SQL).

    No, the plan cache is part of the buffer pool.

    Thanks

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

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