SQL Server2012内存性能计数器和内存DMV的变化
由于2012在内存管理中之前的Single-page Allocator和Multi-page Allocator合并为Any size page Allocator，
所以在一些内存系统视图和性能计数器的内存相关也发生了一些改变。
1、 DMV的改变。
|
SQL Server 2012 |
SQL Server 2008 R2 |
|
sys.dm_os_sys_info |
|
|
physical_memory_kb |
physical_memory_in_bytes |
|
virtual_memory_kb |
virtual_memory_in_bytes |
|
committed_kb |
bpool_committed |
|
committed_target_kb |
bpool_commit_target |
|
visible_target_kb |
bpool_visible |
|
sys.dm_os_memory_nodes |
|
|
pages_kb |
single_pages_kb + |
|
multi_pages_kb |
|
|
foreign_committed_kb |
- |
|
sys.dm_os_memory_cache_counters |
|
|
pages_kb |
single_pages_kb + |
|
multi_pages_kb |
|
|
pages_in_use_kb |
single_pages_in_use_kb |
|
+ multi_pages_in_use_kb |
|
|
sys.dm_os_memory_cache_entries |
|
|
pages_kb |
pages_allocated_count |
|
sys.dm_os_memory_clerks |
|
|
pages_kb |
single_pages_kb + |
|
multi_pages_kb |
|
|
page_size_in_bytes |
page_size_bytes |
|
sys.dm_os_memory_objects |
|
|
pages_in_bytes |
pages_allocated_count |
|
max_pages_in_bytes |
max_pages_allocated_count |
2、性能计数器的改变
性能计数器也是本着合并的原则，更多的趋向于以KB代替Byte或者pages，AWE相关的计数器则被弃用。
|
SQL Server 2012 |
SQL Server 2008 R2 |
|
Object - SQLServer:Memory |
Object - SQLServer:Buffer |
|
Manager |
Manager |
|
Database Cache Memory (KB) |
Database pages |
|
Free Memory (KB) |
Free pages |
|
Reserved Server Memory (KB) |
Reserved pages |
|
Stolen Server Memory (KB) |
Stolen pages |
|
Target Server Memory (KB) |
Target pages |
|
Total Server Memory (KB) |
Total pages |
|
- |
AWE lookup maps / sec |
|
- |
AWE stolen maps / sec |
|
- |
AWE write maps / sec |
|
- |
AWE unmap calls / sec |
|
- |
AWE unmap pages / sec |
|
Object - |
Object - |
|
SQLServer:Memory Node |
SQLServer:Buffer Node |
|
Database Node Memory (KB) |
Database pages |
|
Free Node Memory (KB) |
Free pages |
|
Foreign Node Memory (KB) |
Foreign pages |
|
Stolen Node Memory (KB) |
Stolen pages |
|
Target Node Memory (KB) |
Target pages |
|
Total Node Memory (KB) |
Total pages |
