Durch die Einführung des neuen SQLOS mit SQL 2012 ergeben sich nachfolgend soweit aufgefallen folgende neuen Counter in den System DMW's und Performance 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 zeigt jetzt die Werte von remotememory (anderer Numa Nodes) an.

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

 “Away Commited“ Counter zeigen wieviel des Speichers von RemoteNodes genutzt wird.

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