SQL Server 2012 notes Sharing-6: Understanding Memory Management

Memory Management –sql Server 2005/2008/2008R2

Previous versions of SQL Server 2012 (SQL 2005/2008/2008R2), there are single page allocator and multi page allocator. That is, if the requested memory is within 8k, there will be a single-page allocator allocated, and more than 8kb of memory requests, using the multi page allocator to manage.

Using the SELECT * from sys.dm_os_memory_clerks query memory clerk, you will find single pages and multi pages two columns.

650) this.width=650; "title=" clipboard "style=" Border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clipboard "Src=" Http://img1.51cto.com/attachment/201406/8/639838_14022123975axG.png "height=" 381 "/>

Memory Management –sql Server 2012

SQL Server 2012 no longer has single page allocator and multi page allocator, but unified them together, called any size page allocator.

Using the SELECT * from sys.dm_os_memory_clerks query memory clerk, you will find that the single page and multi page words disappear, leaving only pages.

650) this.width=650; "title=" clipboard[1] "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clipboard [1] "src=" http://img1.51cto.com/attachment/201406/8/639838_1402212404yvLf.png "height=" 417 "/>

As can be seen from the figure above, SQL Server 2012 uses memory manager to uniformly respond to requests for various component memory applications within SQL Server. In SQL Server 2012, Max Server memory is no longer the same as the previous version, only the size of the buffer pool, but also those larger than 8kb memory requests. max server memory provides more precise control over the use of SQL Server.

Reference Documentation:

Memory Manager Configuration changes in SQL Server 2012

Http://sqlblog.com/blogs/sqlos_team/archive/2012/07/12/memory-manager-configuration-changes-in-sql-server-2012.aspx

SQL Server 2012 Memory Management (management) improvements

Http://www.cnblogs.com/stswordman/p/3239754.html

This article from "Zeng Hung Xin Technical column" blog, declined to reprint!