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

转载于:https://www.cnblogs.com/zc_0101/archive/2013/04/17/3026403.html