July 2012 - Posts

SQL Server 2012 and New Perfmon Counters
15 July 12 07:14 AM | MartinBell | with no comments

As well as introducing some new performance counters SQL Server 2012 has also deprecated a few. To see what has changed I compared the values in sys.dm_os_performance_counters for a SQL Server 2008 R2 installation and a SQL Server 2012 RTM version. The perfmon counters no longer in SQL Server 2012 are:

Objects Counter Name
SQLServer:Buffer Manager AWE lookup maps/sec
SQLServer:Buffer Manager AWE stolen maps/sec
SQLServer:Buffer Manager AWE unmap calls/sec
SQLServer:Buffer Manager AWE unmap pages/sec
SQLServer:Buffer Manager AWE write maps/sec
SQLServer:Buffer Manager Free pages
SQLServer:Buffer Manager Reserved pages
SQLServer:Buffer Manager Stolen pages
SQLServer:Buffer Manager Total pages
SQLServer:Buffer Node Foreign pages
SQLServer:Buffer Node Free pages
SQLServer:Buffer Node Stolen pages
SQLServer:Buffer Node Target pages
SQLServer:Buffer Node Total pages
SQLServer:Buffer Partition Free list empty/sec
SQLServer:Buffer Partition Free list requests/sec
SQLServer:Buffer Partition Free pages

New counters are:

Objects Counter Name 
SQLServer:Access Methods InSysXact waits/sec 
SQLServer:Availability Replica Bytes Received from Replica/sec 
SQLServer:Availability Replica Bytes Sent to Replica/sec 
SQLServer:Availability Replica Bytes Sent to Transport/sec 
SQLServer:Availability Replica Flow Control Time (ms/sec) 
SQLServer:Availability Replica Flow Control/sec 
SQLServer:Availability Replica Receives from Replica/sec 
SQLServer:Availability Replica Resent Messages/sec 
SQLServer:Availability Replica Sends to Replica/sec 
SQLServer:Availability Replica Sends to Transport/sec 
SQLServer:Batch Resp Statistics Batches >=000000ms & <000001ms 
SQLServer:Batch Resp Statistics Batches >=000001ms & <000002ms 
SQLServer:Batch Resp Statistics Batches >=000002ms & <000005ms 
SQLServer:Batch Resp Statistics Batches >=000005ms & <000010ms 
SQLServer:Batch Resp Statistics Batches >=000010ms & <000020ms 
SQLServer:Batch Resp Statistics Batches >=000020ms & <000050ms 
SQLServer:Batch Resp Statistics Batches >=000050ms & <000100ms 
SQLServer:Batch Resp Statistics Batches >=000100ms & <000200ms 
SQLServer:Batch Resp Statistics Batches >=000200ms & <000500ms 
SQLServer:Batch Resp Statistics Batches >=000500ms & <001000ms 
SQLServer:Batch Resp Statistics Batches >=001000ms & <002000ms 
SQLServer:Batch Resp Statistics Batches >=002000ms & <005000ms 
SQLServer:Batch Resp Statistics Batches >=005000ms & <010000ms 
SQLServer:Batch Resp Statistics Batches >=010000ms & <020000ms 
SQLServer:Batch Resp Statistics Batches >=020000ms & <050000ms 
SQLServer:Batch Resp Statistics Batches >=050000ms & <100000ms 
SQLServer:Batch Resp Statistics Batches >=100000ms 
SQLServer:Buffer Manager Background writer pages/sec 
SQLServer:Buffer Manager Integral Controller Slope 
SQLServer:Database Replica File Bytes Received/sec 
SQLServer:Database Replica Log Bytes Received/sec 
SQLServer:Database Replica Log remaining for undo 
SQLServer:Database Replica Log Send Queue 
SQLServer:Database Replica Mirrored Write Transactions/sec 
SQLServer:Database Replica Recovery Queue 
SQLServer:Database Replica Redo blocked/sec 
SQLServer:Database Replica Redo Bytes Remaining 
SQLServer:Database Replica Redone Bytes/sec 
SQLServer:Database Replica Total Log requiring undo 
SQLServer:Database Replica Transaction Delay 
SQLServer:Databases Log Flush Write Time (ms) 
SQLServer:Databases Log Pool Cache Misses/sec 
SQLServer:Databases Log Pool Disk Reads/sec 
SQLServer:Databases Log Pool Requests/sec 
SQLServer:FileTable Avg time delete FileTable item 
SQLServer:FileTable Avg time FileTable enumeration 
SQLServer:FileTable Avg time FileTable handle kill 
SQLServer:FileTable Avg time move FileTable item 
SQLServer:FileTable Avg time per file I/O request 
SQLServer:FileTable Avg time per file I/O response 
SQLServer:FileTable Avg time rename FileTable item 
SQLServer:FileTable Avg time to get FileTable item 
SQLServer:FileTable Avg time update FileTable item 
SQLServer:FileTable FileTable db operations/sec 
SQLServer:FileTable FileTable enumeration reqs/sec 
SQLServer:FileTable FileTable file I/O requests/sec 
SQLServer:FileTable FileTable file I/O response/sec 
SQLServer:FileTable FileTable item delete reqs/sec 
SQLServer:FileTable FileTable item get requests/sec 
SQLServer:FileTable FileTable item move reqs/sec 
SQLServer:FileTable FileTable item rename reqs/sec 
SQLServer:FileTable FileTable item update reqs/sec 
SQLServer:FileTable FileTable kill handle ops/sec 
SQLServer:FileTable FileTable table operations/sec 
SQLServer:FileTable Time delete FileTable item BASE 
SQLServer:FileTable Time FileTable enumeration BASE 
SQLServer:FileTable Time FileTable handle kill BASE 
SQLServer:FileTable Time move FileTable item BASE 
SQLServer:FileTable Time per file I/O request BASE 
SQLServer:FileTable Time per file I/O response BASE 
SQLServer:FileTable Time rename FileTable item BASE 
SQLServer:FileTable Time to get FileTable item BASE 
SQLServer:FileTable Time update FileTable item BASE 
SQLServer:Memory Broker Clerks Internal benefit 
SQLServer:Memory Broker Clerks Memory broker clerk size 
SQLServer:Memory Broker Clerks Periodic evictions (pages) 
SQLServer:Memory Broker Clerks Pressure evictions (pages/sec) 
SQLServer:Memory Broker Clerks Simulation benefit 
SQLServer:Memory Broker Clerks Simulation size 
SQLServer:Memory Manager Database Cache Memory (KB) 
SQLServer:Memory Manager External benefit of memory 
SQLServer:Memory Manager Free Memory (KB) 
SQLServer:Memory Manager Log Pool Memory (KB) 
SQLServer:Memory Manager Reserved Server Memory (KB) 
SQLServer:Memory Manager Stolen Server Memory (KB) 
SQLServer:Memory Node Database Node Memory (KB) 
SQLServer:Memory Node Foreign Node Memory (KB) 
SQLServer:Memory Node Free Node Memory (KB) 
SQLServer:Memory Node Stolen Node Memory (KB) 
SQLServer:Memory Node Target Node Memory (KB) 
SQLServer:Memory Node Total Node Memory (KB) 
SQLServer:Query Execution Local data access/sec 
SQLServer:Query Execution Rem Req Cache Hit Ratio 
SQLServer:Query Execution Rem Req Cache Hit Ratio Base 
SQLServer:Query Execution Remote activations/sec 
SQLServer:Query Execution Remote requests/sec 
SQLServer:Query Execution Remote resend requests/sec 

I have incorporated these changes into the SQLDiag templates mentioned in my previous post.

Filed under: ,

This Blog

SQL Blogs

Syndication