SQL Server 2012 performance counters

SQL Server 2012 performance counters and DMV changes compared to SQL 2008 with new SQLOS


With the introduction of the new SQL 2012 SQLOS emerge below as far noticed the following new counters in the DMV system's performance and monitor:


sys.dm_os_memory_nodes

SQL Server 2012	SQL Server 2008 R2
pages_kb	single_pages_kb +   multi_pages_kb
foreign_committed_kb	-

"Foreign_commited_kb now displays the values ​​of remote memory (Numa other nodes). 


sys.dm_os_sys_info

SQL Server 2012	SQL Server 2008 R2
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_cache_counters

SQL Server 2012	SQL Server 2008 R2
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

SQL Server 2012	SQL Server 2008 R2
pages_kb	pages_allocated_count

sys.dm_os_memory_clerks

SQL Server 2012	SQL Server 2008 R2
pages_kb	single_pages_kb +   multi_pages_kb
page_size_in_bytes	page_size_bytes

sys.dm_os_memory_objects

SQL Server 2012	SQL Server 2008 R2
pages_in_bytes	pages_allocated_count
max_pages_in_bytes	max_pages_allocated_count

DBCC Memory Status changes

SQL Server   2012	SQL Server   2008 R2
Memory Manager \   Large Pages Allocated	-
Memory Manager \   Emergency Memory	Memory Manager \   Reserved Memory
Memory Manager \ Emergency   Memory In Use	Memory Manager \   Reserved Memory In Use
Memory Manager \   Target Committed (KB)	Buffer Pool \   Target (Pages)
Memory Manager \   Current Committed (KB)	Buffer Pool \   Committed (Pages)
Memory Manager \   Pages Allocated (KB)	Buffer Pool \   Stolen (Pages) + Buffer Pool \ Database (Pages)
Memory Manager \   Pages Reserved (KB)	Buffer Pool \   Reserved (Pages)
Memory Manager \   Pages Free (KB)	Buffer Pool \ Free   (Pages)
Memory Manager \   Pages In Use	-
Memory Manager \   Page Alloc Potential (KB)	Buffer Pool \   Stolen Potential (Pages)
Memory Manager \   NUMA Growth Phase	-
Memory Manager \   Last OOM Factor	Buffer Pool \ Last   OOM Factor
Memory Manager \   Last OS Error	-
Memory Manager \   Large Pages Allocated	-
Memory Manager \   Emergency Memory	Memory Manager \   Reserved Memory
Memory Manager \   Emergency Memory In Use	Memory Manager \   Reserved Memory In Use
Memory Manager \   Target Committed (KB)	Buffer Pool \   Target (Pages)
Memory Manager \ Current   Committed (KB)	Buffer Pool \   Committed (Pages)
Memory Manager \   Pages Allocated (KB)	Buffer Pool \   Stolen (Pages) + Buffer Pool \ Database (Pages)
Memory Manager \   Pages Reserved (KB)	Buffer Pool \   Reserved (Pages)
Memory Manager \   Pages Free (KB)	Buffer Pool \ Free   (Pages)
Memory Manager \   Pages In Use	-
Memory Manager \   Page Alloc Potential (KB)	Buffer Pool \   Stolen Potential (Pages)
Memory Manager \   NUMA Growth Phase	-
Memory Manager \   Last OOM Factor	Buffer Pool \ Last   OOM Factor
Memory Manager \   Last OS Error	-
Memory node Id = n   \ Pages Allocated	Memory node Id = n   \ MultiPage Allocator + Memory node Id = n \ SinglePage Allocator
Memory node Id = n   \ Target Committed	-
Memory node Id = n   \ Current Committed	-
Memory node Id = n   \ Foreign Committed	-
Memory node Id = n   \ Away Committed	-
Memory Clerks \   Pages Allocated	Memory Clerks \   SinglePage Allocator + Memory Clerks \ MultiPage Allocator

"Committed Away" Counter is used to show how much of the memory of remote nodes.
 

Performance monitor counters

SQL Server 2012	SQL Server 2008 R2
Object - SQLServer:Memory   Manager	Object - SQLServer:Buffer   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 -   SQLServer:Memory Node		Object -   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 page