• benjamin.reyes (10/28/2011)


    For example on one of my machines I have max memory set at 26,624 MB, which is my buffer size, the plan cache is an additional 4,408 MB.

    The plan cache is part of the buffer cache, so your plan cache takes up 4408MB of the 26624MB buffer pool. What's outside of the buffer pool is things like CLR memory, backup buffers, thread stacks, linked server drivers and a couple other things. They're generally smallish memory allocations

    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