Memory Architecture

• SQLSACT

  SSC-Insane

  Points: 21838

  More actions

  November 14, 2012 at 1:16 am

  #393599

  Hi All

  After scurraging through the internet trying to understand the SQL Server buffer pool, I understand the following but I am still not sure about 1 or 2 things

  Buffer Pool size is set by setting a max server memory (MB) in sp_configure

  The Buffer pool is then divided between the data cache, plan cache and a few other smaller caches.

  Where does the multipage allocator reside and what controls it? Is this completely seperate from the above? Is this given from OS memory?

  If a query, execution plan etc needs less than 8KB, it is granted through the buffer pool. If something requires a page that is more than 8KB is size, the MP allocator takes care of this?

  Please help with some clarification

  Thanks

• hs24

  Default port

  Points: 1440

  More actions

  November 14, 2012 at 5:32 am

  #1558870

  Have a look at this article http://www.sqlservercentral.com/articles/Memory/74867/

  The MPA resides in the windows system cache