How cntr_value in table sysperfinfo is analysed | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How cntr_value in table sysperfinfo is analysed

How the field cntr_value in table sysperfinfo be help ful in performance tuning.How this value should be analysed for various counters.
Books online refers
Actual counter value. In most cases, this will be a level or monotonically increasing counter that counts occurrences of the instance event.
The system table, "sysperfinfo," is the representation of the internal performance counters of SQL Server. about using this system table effectively. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.