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. http://www.databasejournal.com/features/mssql/article.php/3427231 about using this system table effectively. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>