SQL2012 upgrade 되면서 메모리 관리 아키텍쳐가 변경되었다.  이제는 어떻게 메모리 설정하는게 좋을까? 고민되네~~

- 읽어볼 내용들

http://blog.beyondrelational.com/modules/24/syndicated/389/Posts/13492/any-size-page-allocator-memory-allocation-changes-with-sql-2012.aspx

http://sqlskills.com/blogs/jonathan/post/How-much-memory-does-my-SQL-Server-actually-need.aspx

http://sqlblog.com/blogs/tibor_karaszi/archive/2014/03/06/setting-max-server-memory.aspx  -- 최대 메모리 설정 쿼리

- Memory Manager Redesign:

Predictable sizing and governing SQL memory consumption:

sp_configure ‘max server memory’ now limits all memory committed by SQL Server
Resource Governor governs all SQL memory consumption (other than special cases like buffer pool)

Improved scalability of complex queries and operations that make >8K allocations

Improved CPU and NUMA locality for memory accesses

Single memory manager that handles page allocations of all sizes

Consistent Out-of-memory handling & management across different internal components

SQL2012 이전 버젼에서 Max memory 관련 설정 할때 나름 공식이 있었는데 이부분이 변경되었다고 하니, 새로운 공식을 만들어야겠네요. 좀더 자세히 정리해보아야겠습니다.

sys.dm_os_memory_clerks system view에서 multi_pages_kb으 열이 제거되었습니다. 

Glenn Berry's 

Suggested Max Memory Settings for SQL Server 2005/2008

http://www.sqlservercentral.com/blogs/glennberry/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008/

SQL TAG

http://cafe.naver.com/sqlmvp/600

Cool... Now we have a calculator for finding out a Max. Server Memory value

http://www.texastoo.com/post/2012/05/20/Best-of-MSDN-Blogs%E2%80%93Calculator-for-finding-out-a-Max-Server-Memory-value.aspx

http://blogs.msdn.com/b/sqlsakthi/archive/2012/05/19/cool-now-we-have-a-calculator-for-finding-out-a-max-server-memory-value.aspx

http://blogs.msdn.com/b/sqlsakthi/p/max-server-memory-calculator.aspx