Memory Architecture

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Memory Architecture

Memory Architecture

Rate Topic

Display Mode

Topic Options

Author

Message

SQLSACT

Posted Wednesday, November 14, 2012 1:16 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:22 AM
Points: 1,258, Visits: 2,232

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

Post #1384436

hs24

Posted Wednesday, November 14, 2012 5:32 AM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 9:22 AM
Points: 765, Visits: 332

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

The MPA resides in the windows system cache

Post #1384562

« Prev Topic | Next Topic »

Permissions