sql server perfmon counters
Simply so I can find it later.
Memory / Available MBytes
Paging File / % Usage
Physical Disk / % Disk Time
Physical Disk / Avg. Disk Queue Length
Physical Disk / Avg. Disk sec/Read
Physical Disk / Avg. Disk sec/Write
Physical Disk / Disk Reads/sec
Physical Disk / Disk Writes/sec
Processor / % Processor Time
SQLServer:Buffer Manager / Buffer cache hit ratio
SQLServer:Buffer Manager / Page life expectancy
SQLServer:General Statistics / User Connections
SQLServer:Memory Manager / Memory Grants Pending
System / Processor Queue Length
I’ll add notes about what these values should be and what they mean later…
