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