• Akkare (1/21/2013)


    BufferPool

    Pages of data stored in memory. Governed by 'max server memory' setting.

    VAS

    Memtoleave

    Two names for the same thing. Describes bon-buffer-pool memory, i.e. amount is not governed by 'max server memory' setting. Think of this as memory SQL Server needs to support things like CLR objects and Linked Server requests.

    Understanding the VAS Reservation (aka MemToLeave) in SQL Server by Jonathan Kehayias

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato