Memory configuration and sizing considerations in SQL Server 2012

SQL2012 메모리 사이즈 정책 관련 자료가 올라왔네요.

http://blogs.msdn.com/b/sqlosteam/archive/2012/06/20/sql-server-2012-memory-manager-kb-articles.aspx

 

How has memory sizing changed in SQL 2012?

2663912 Memory configuration and sizing considerations in SQL Server 2012 -http://support.microsoft.com/default.aspx?scid=kb;EN-US;2663912  

 

Setting "locked pages" to avoid SQL Server memory pages getting swapped has been simplified, particularly for Standard Edition, the details can be found here:

2659143 How to enable the "locked pages" feature in SQL Server 2012 - http://support.microsoft.com/default.aspx?scid=kb;EN-US;2659143

 

Note the following deprecation (particularly relevant for 32-bit installations):

2644592 The "AWE enabled" SQL Server feature is deprecated - http://support.microsoft.com/default.aspx?scid=kb;EN-US;2644592 

(AWE Enable하는 옵션이 완전 없어졌군요.)

 

Note the following fixes available:

2708594 FIX: Locked page allocations are enabled without any warning after you upgrade to SQL Server 2012 -http://support.microsoft.com/kb/2708594/EN-US

2688697 FIX: Out-of-memory error when you run an instance of SQL Server 2012 on a computer that uses NUMA -http://support.microsoft.com/kb/2688697/EN-US

SQL Server Max Memory Myths Video
http://www.brentozar.com/archive/2012/06/sql-server-max-memory-myths-video/