Robert.Sterbal (11/8/2010)
A really neat product, I'm especially interested in how you came up with this list of performance counters, and if the list is considered proprietary:Machine: processor time
Avg. CPU queue length
Machine: memory used
Memory pages/sec
Network utilization
Disk used
Disk avg. read time
Disk avg. write time
Disk transfers/sec
Avg. disk queue length
User connections
SQL Server: processor time
SQL Server: total memory
SQL Server: target memory
Batch requests/sec
Compilations/sec
Compilations/batch
Recompilations/sec
Buffer cache hit ratio
Buffer free pages
Buffer page life expectancy
Full scans/sec
Page splits/sec
Page splits/batch request
Latch wait time
Lock timeouts/sec
Lock waits/sec
Avg. lock wait time
Transactions/sec
Active transactions
Total size
Data size
Log size
Log space used
Log bytes flushed/sec
Log flushes/sec
Log flush waits/sec
Thanks for the wonderful detail about each counter. It would be nice to see it posted on this website.
about 9 months ago i started to really monitor our SQL servers and set up perfmon. i just selected any counter which i thought could be remotely useful. made some reports in SSIS but haven't had much time for really doing something with the data