'memory'에 해당되는 글 1건

  1. Memory Manager surface area changes in SQL Server 2012

"변경된 SQL2012의 메모리 관리" 드뎌 올라왔다.


1. memory counters as "kb"

2. any-size page allocator

3. central role of the redesigned Memory Manager


어디보자. 다시 익히려면 애좀 먹겠군. ㅠㅠ

http://blogs.msdn.com/b/sqlosteam/archive/2012/07/11/memory-manager-surface-area-changes-in-sql-server-2012.aspx

http://blogs.msdn.com/b/sqlosteam/archive/2012/07/12/memory-manager-configuration-changes-in-sql-server-2012.aspx


Memory Manager


Max server memory


DWA : direct Windows allocations

SQL Server 2012

Sp_configure option

Default setting

Lowest possible value

Highest possible value

Min server memory

0

16 (MB)

Value
  less than max server

memory setting

Max
  server memory

2147483647

(available memory in the system)

32 bit - 64 (MB)

64 bit – 128 (MB)

2147483647

(available memory in the

system)

'SQL Server 2012' 카테고리의 다른 글

Free ebook  (0) 2012.08.07
Resource Governor in SQL Server 2012  (0) 2012.07.31
Wait Type in SQL2012  (0) 2012.07.09
이건 Bug 일까?  (0) 2012.06.27
Memory configuration and sizing considerations in SQL Server 2012  (0) 2012.06.21