"변경된 SQL2012의 메모리 관리" 드뎌 올라왔다.
1. memory counters as "kb"
2. any-size page allocator
3. central role of the redesigned Memory Manager
어디보자. 다시 익히려면 애좀 먹겠군. ㅠㅠ
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 memory setting |
Max | 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 |