Performance counters

LIst of performance counters defined and collected by SQLWATCH. For the actual colleciton please check the [collect] column where 1 indicates that the counter is collected and 0 indicates that it is not collected.

object_name

instance_name

counter_name

base_counter_name

collect

Access Methods

Forwarded Records/sec

NULL

0

Access Methods

Full Scans/sec

NULL

1

Access Methods

Index Searches/sec

NULL

1

Access Methods

Page compression attempts/sec

NULL

1

Access Methods

Page Deallocations/sec

NULL

1

Access Methods

Page Splits/sec

NULL

1

Access Methods

Pages Allocated/sec

NULL

1

Access Methods

Pages compressed/sec

NULL

1

Access Methods

Table Lock Escalations/sec

NULL

0

Availability Replica

_Total

Bytes Received from Replica/sec

NULL

0

Availability Replica

_Total

Bytes Sent to Replica/sec

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=000000ms & <000001ms

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=000001ms & <000002ms

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=000002ms & <000005ms

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=000005ms & <000010ms

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=000010ms & <000020ms

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=000020ms & <000050ms

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=000050ms & <000100ms

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=000100ms & <000200ms

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=000200ms & <000500ms

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=000500ms & <001000ms

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=001000ms & <002000ms

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=002000ms & <005000ms

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=005000ms & <010000ms

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=010000ms & <020000ms

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=020000ms & <050000ms

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=050000ms & <100000ms

NULL

0

Batch Resp Statistics

CPU Time:Requests

Batches >=100000ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=000000ms & <000001ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=000001ms & <000002ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=000002ms & <000005ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=000005ms & <000010ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=000010ms & <000020ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=000020ms & <000050ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=000050ms & <000100ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=000100ms & <000200ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=000200ms & <000500ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=000500ms & <001000ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=001000ms & <002000ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=002000ms & <005000ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=005000ms & <010000ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=010000ms & <020000ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=020000ms & <050000ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=050000ms & <100000ms

NULL

0

Batch Resp Statistics

CPU Time:Total(ms)

Batches >=100000ms

NULL

0

Batch Resp Statistics

Elappsed Time:Requests

Batches >=000010ms & <000020ms

NULL

0

Batch Resp Statistics

Elapsed Time:Requests

Batches >=000000ms & <000001ms

NULL

0

Batch Resp Statistics

Elapsed Time:Requests

Batches >=000001ms & <000002ms

NULL

0

Batch Resp Statistics

Elapsed Time:Requests

Batches >=000002ms & <000005ms

NULL

0

Batch Resp Statistics

Elapsed Time:Requests

Batches >=000005ms & <000010ms

NULL

0

Batch Resp Statistics

Elapsed Time:Requests

Batches >=000020ms & <000050ms

NULL

0

Batch Resp Statistics

Elapsed Time:Requests

Batches >=000050ms & <000100ms

NULL

0

Batch Resp Statistics

Elapsed Time:Requests

Batches >=000100ms & <000200ms

NULL

0

Batch Resp Statistics

Elapsed Time:Requests

Batches >=000200ms & <000500ms

NULL

0

Batch Resp Statistics

Elapsed Time:Requests

Batches >=000500ms & <001000ms

NULL

0

Batch Resp Statistics

Elapsed Time:Requests

Batches >=001000ms & <002000ms

NULL

0

Batch Resp Statistics

Elapsed Time:Requests

Batches >=002000ms & <005000ms

NULL

0

Batch Resp Statistics

Elapsed Time:Requests

Batches >=005000ms & <010000ms

NULL

0

Batch Resp Statistics

Elapsed Time:Requests

Batches >=010000ms & <020000ms

NULL

0

Batch Resp Statistics

Elapsed Time:Requests

Batches >=020000ms & <050000ms

NULL

0

Batch Resp Statistics

Elapsed Time:Requests

Batches >=050000ms & <100000ms

NULL

0

Batch Resp Statistics

Elapsed Time:Requests

Batches >=100000ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=000000ms & <000001ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=000001ms & <000002ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=000002ms & <000005ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=000005ms & <000010ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=000010ms & <000020ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=000020ms & <000050ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=000050ms & <000100ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=000100ms & <000200ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=000200ms & <000500ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=000500ms & <001000ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=001000ms & <002000ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=002000ms & <005000ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=005000ms & <010000ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=010000ms & <020000ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=020000ms & <050000ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=050000ms & <100000ms

NULL

0

Batch Resp Statistics

Elapsed Time:Total(ms)

Batches >=100000ms

NULL

0

Buffer Manager

Background writer pages/sec

NULL

0

Buffer Manager

Buffer cache hit ratio

Buffer cache hit ratio base

1

Buffer Manager

Buffer cache hit ratio base

NULL

1

Buffer Manager

Checkpoint pages/sec

NULL

1

Buffer Manager

Free list stalls/sec

NULL

1

Buffer Manager

Lazy writes/sec

NULL

1

Buffer Manager

Page lookups/sec

NULL

1

Buffer Manager

Page reads/sec

NULL

1

Buffer Manager

Page writes/sec

NULL

1

Buffer Manager

Readahead pages/sec

NULL

1

Buffer Manager

Workfiles Created/sec

NULL

1

Buffer Manager

Worktables Created/sec

NULL

1

Buffer Node

000

Page life expectancy

NULL

1

Database Replica

_Total

File Bytes Received/sec

NULL

0

Database Replica

_Total

Log Bytes Received/sec

NULL

0

Database Replica

_Total

Log remaining for undo

NULL

0

Database Replica

_Total

Log Send Queue

NULL

0

Database Replica

_Total

Mirrored Write Transactions/sec

NULL

0

Database Replica

_Total

Recovery Queue

NULL

0

Database Replica

_Total

Redo blocked/sec

NULL

0

Database Replica

_Total

Redo Bytes Remaining

NULL

0

Database Replica

_Total

Redone Bytes/sec

NULL

0

Database Replica

_Total

Total Log requiring undo

NULL

0

Database Replica

_Total

Transaction Delay

NULL

0

Databases

_Total

Active Transactions

NULL

1

Databases

_Total

Checkpoint duration

NULL

0

Databases

_Total

Group Commit Time/sec

NULL

0

Databases

_Total

Log Bytes Flushed/sec

NULL

0

Databases

_Total

Log Flush Waits/sec

NULL

0

Databases

_Total

Log Flushes/sec

NULL

1

Databases

_Total

Log Growths

NULL

1

Databases

_Total

Log Shrinks

NULL

1

Databases

_Total

Log Truncations

NULL

1

Databases

_Total

Write Transactions/sec

NULL

1

Databases

<* !_Total>

Percent Log Used

NULL

0

Databases

<* !_Total>

Transactions/sec

NULL

1

Databases

tempdb

Checkpoint duration

NULL

0

Databases

tempdb

Group Commit Time/sec

NULL

0

Databases

tempdb

Log Bytes Flushed/sec

NULL

0

Databases

tempdb

Log Flush Waits/sec

NULL

0

Databases

tempdb

Log Flushes/sec

NULL

0

Databases

tempdb

Log Growths

NULL

0

Databases

tempdb

Percent Log Used

NULL

0

Databases

tempdb

Transactions/sec

NULL

0

Databases

tempdb

Write Transactions/sec

NULL

0

General Statistics

Active Temp Tables

NULL

1

General Statistics

Logical Connections

NULL

0

General Statistics

Logins/sec

NULL

1

General Statistics

Logouts/sec

NULL

0

General Statistics

Processes blocked

NULL

1

General Statistics

Temp Tables Creation Rate

NULL

1

General Statistics

User Connections

NULL

1

HTTP Storage

<* !_Total>

Avg. Bytes/Read

Avg. Bytes/Read BASE

0

HTTP Storage

<* !_Total>

Avg. Bytes/Read BASE

NULL

0

HTTP Storage

<* !_Total>

Avg. Bytes/Transfer

Avg. Bytes/Transfer BASE

0

HTTP Storage

<* !_Total>

Avg. Bytes/Transfer BASE

NULL

0

HTTP Storage

<* !_Total>

Avg. Bytes/Write

Avg. Bytes/Write BASE

0

HTTP Storage

<* !_Total>

Avg. Bytes/Write BASE

NULL

0

HTTP Storage

<* !_Total>

Avg. microsec/Read

Avg. microsec/Read BASE

0

HTTP Storage

<* !_Total>

Avg. microsec/Read BASE

NULL

0

HTTP Storage

<* !_Total>

Avg. microsec/Read Comp

Avg. microsec/Read Comp BASE

0

HTTP Storage

<* !_Total>

Avg. microsec/Read Comp BASE

NULL

0

HTTP Storage

<* !_Total>

Avg. microsec/Transfer

Avg. microsec/Transfer BASE

0

HTTP Storage

<* !_Total>

Avg. microsec/Transfer BASE

NULL

0

HTTP Storage

<* !_Total>

Avg. microsec/Write

Avg. microsec/Write BASE

0

HTTP Storage

<* !_Total>

Avg. microsec/Write BASE

NULL

0

HTTP Storage

<* !_Total>

Avg. microsec/Write Comp

Avg. microsec/Write Comp BASE

0

HTTP Storage

<* !_Total>

Avg. microsec/Write Comp BASE

NULL

0

HTTP Storage

<* !_Total>

HTTP Storage IO failed/sec

NULL

0

HTTP Storage

<* !_Total>

HTTP Storage IO retry/sec

NULL

0

HTTP Storage

<* !_Total>

Outstanding HTTP Storage IO

NULL

0

HTTP Storage

<* !_Total>

Read Bytes/Sec

NULL

0

HTTP Storage

<* !_Total>

Reads/Sec

NULL

0

HTTP Storage

<* !_Total>

Total Bytes/Sec

NULL

0

HTTP Storage

<* !_Total>

Transfers/Sec

NULL

0

HTTP Storage

<* !_Total>

Write Bytes/Sec

NULL

0

HTTP Storage

<* !_Total>

Writes/Sec

NULL

0

Latches

Latch Waits/sec

NULL

1

Locks

_Total

Average Wait Time (ms)

Average Wait Time Base

1

Locks

_Total

Average Wait Time Base

NULL

1

Locks

_Total

Lock Requests/sec

NULL

1

Locks

_Total

Lock Timeouts (timeout > 0)/sec

NULL

0

Locks

_Total

Lock Timeouts/sec

NULL

1

Locks

_Total

Lock Waits/sec

NULL

1

Locks

_Total

Number of Deadlocks/sec

NULL

1

Memory Manager

Connection Memory (KB)

NULL

1

Memory Manager

Lock Memory (KB)

NULL

1

Memory Manager

Memory Grants Outstanding

NULL

1

Memory Manager

Memory Grants Pending

NULL

1

Memory Manager

Optimizer Memory (KB)

NULL

1

Memory Manager

SQL Cache Memory (KB)

NULL

1

Memory Manager

Stolen Server Memory (KB)

NULL

1

Memory Manager

Target Server Memory (KB)

NULL

1

Memory Manager

Total Server Memory (KB)

NULL

1

Plan Cache

_Total

Cache Hit Ratio

Cache Hit Ratio Base

0

Plan Cache

_Total

Cache Hit Ratio Base

NULL

0

Plan Cache

_Total

Cache Object Counts

NULL

0

Resource Pool Stats

internal

Active memory grant amount (KB)

NULL

0

Resource Pool Stats

internal

Active memory grants count

NULL

0

Resource Pool Stats

internal

Avg Disk Read IO (ms)

Avg Disk Read IO (ms) Base

0

Resource Pool Stats

internal

Avg Disk Read IO (ms) Base

NULL

0

Resource Pool Stats

internal

Avg Disk Write IO (ms)

Avg Disk Write IO (ms) Base

0

Resource Pool Stats

internal

Avg Disk Write IO (ms) Base

NULL

0

Resource Pool Stats

internal

Cache memory target (KB)

NULL

0

Resource Pool Stats

internal

Compile memory target (KB)

NULL

0

Resource Pool Stats

internal

CPU control effect %

NULL

0

Resource Pool Stats

internal

CPU delayed %

CPU delayed % base

0

Resource Pool Stats

internal

CPU delayed % base

NULL

0

Resource Pool Stats

internal

CPU effective %

CPU effective % base

0

Resource Pool Stats

internal

CPU effective % base

NULL

0

Resource Pool Stats

internal

CPU usage %

CPU usage % base

0

Resource Pool Stats

internal

CPU usage % base

NULL

0

Resource Pool Stats

internal

CPU usage target %

NULL

0

Resource Pool Stats

internal

CPU violated %

NULL

0

Resource Pool Stats

internal

Disk Read Bytes/sec

NULL

0

Resource Pool Stats

internal

Disk Read IO Throttled/sec

NULL

0

Resource Pool Stats

internal

Disk Read IO/sec

NULL

0

Resource Pool Stats

internal

Disk Write Bytes/sec

NULL

0

Resource Pool Stats

internal

Disk Write IO Throttled/sec

NULL

0

Resource Pool Stats

internal

Disk Write IO/sec

NULL

0

Resource Pool Stats

internal

Max memory (KB)

NULL

0

Resource Pool Stats

internal

Memory grant timeouts/sec

NULL

0

Resource Pool Stats

internal

Memory grants/sec

NULL

0

Resource Pool Stats

internal

Pending memory grants count

NULL

0

Resource Pool Stats

internal

Query exec memory target (KB)

NULL

0

Resource Pool Stats

internal

Target memory (KB)

NULL

0

Resource Pool Stats

internal

Used memory (KB)

NULL

0

SQL Errors

_Total

Errors/sec

NULL

1

SQL Errors

DB Offline Errors

Errors/sec

NULL

0

SQL Errors

Kill Connection Errors

Errors/sec

NULL

0

SQL Errors

User Errors

Errors/sec

NULL

0

SQL Statistics

Auto-Param Attempts/sec

NULL

1

SQL Statistics

Batch Requests/sec

NULL

1

SQL Statistics

Failed Auto-Params/sec

NULL

1

SQL Statistics

Forced Parameterizations/sec

NULL

1

SQL Statistics

SQL Attention rate

NULL

0

SQL Statistics

SQL Compilations/sec

NULL

1

SQL Statistics

SQL Re-Compilations/sec

NULL

1

Transactions

Free Space in tempdb (KB)

NULL

1

Transactions

Longest Transaction Running Time

NULL

0

Transactions

Version Cleanup rate (KB/s)

NULL

0

Transactions

Version Generation rate (KB/s)

NULL

0

Wait Statistics

Average wait time (ms)

Log write waits

NULL

1

Wait Statistics

Average wait time (ms)

Network IO waits

NULL

1

Wait Statistics

Average wait time (ms)

Page IO latch waits

NULL

1

Wait Statistics

Average wait time (ms)

Page latch waits

NULL

1

Wait Statistics

Cumulative wait time (ms) per second

Lock waits

NULL

0

Wait Statistics

Cumulative wait time (ms) per second

Memory grant queue waits

NULL

0

Wait Statistics

Cumulative wait time (ms) per second

Network IO waits

NULL

0

Wait Statistics

Cumulative wait time (ms) per second

Non-Page latch waits

NULL

0

Wait Statistics

Cumulative wait time (ms) per second

Page IO latch waits

NULL

1

Wait Statistics

Cumulative wait time (ms) per second

Page latch waits

NULL

1

Wait Statistics

Cumulative wait time (ms) per second

Wait for the worker

NULL

0

Win32_PerfFormattedData_PerfOS_Processor

SQL

Idle Time %

NULL

1

Win32_PerfFormattedData_PerfOS_Processor

SQL

Processor Time %

NULL

1

Win32_PerfFormattedData_PerfOS_Processor

System

Processor Time %

NULL

1

Workload Group Stats

internal

Active parallel threads

NULL

0

Workload Group Stats

internal

Active requests

NULL

0

Workload Group Stats

internal

Avg Disk msec/Read

Disk msec/Read Base

0

Workload Group Stats

internal

Avg Disk msec/Write

Disk msec/Write Base

0

Workload Group Stats

internal

Blocked tasks

NULL

0

Workload Group Stats

internal

CPU delayed %

CPU delayed % base

0

Workload Group Stats

internal

CPU delayed % base

NULL

0

Workload Group Stats

internal

CPU effective %

CPU effective % base

0

Workload Group Stats

internal

CPU effective % base

NULL

0

Workload Group Stats

internal

CPU usage %

CPU usage % base

0

Workload Group Stats

internal

CPU usage % base

NULL

0

Workload Group Stats

internal

CPU violated %

NULL

0

Workload Group Stats

internal

Disk msec/Read Base

NULL

0

Workload Group Stats

internal

Disk msec/Write Base

NULL

0

Workload Group Stats

internal

Disk Read Bytes/sec

NULL

0

Workload Group Stats

internal

Disk Reads/sec

NULL

0

Workload Group Stats

internal

Disk Violations/sec

NULL

0

Workload Group Stats

internal

Disk Write Bytes/sec

NULL

0

Workload Group Stats

internal

Disk Writes/sec

NULL

0

Workload Group Stats

internal

Max request cpu time (ms)

NULL

0

Workload Group Stats

internal

Max request memory grant (KB)

NULL

0

Workload Group Stats

internal

Query optimizations/sec

NULL

0

Workload Group Stats

internal

Queued requests

NULL

0

Workload Group Stats

internal

Reduced memory grants/sec

NULL

0

Workload Group Stats

internal

Requests completed/sec

NULL

0

Workload Group Stats

internal

Suboptimal plans/sec

NULL

0