Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

If you have the counter information available, you can enter the information quickly by simply pasting or typing the Object Name, Counter Name, and Instance name into their associated fields. The counter information entered must be exact or the counter does not work correctly.
 

To select a SQL Server system counter:

...

You can open the Add Custom Counter wizard by clicking Administration > Custom Counters, and then clicking Add in the Custom Counters view.

How to calculate this metric

For more information about the algorithm used to calculate a specific metric, see SQL Diagnostic Manager cannot load the performance counters needed for the statistics view pane - Solution #00000133 IDERA Solution available at the

Newtablink
aliasCustomer Support Portal
urlhttps://idera.secure.force.com/
.

Understand why the SQL Server counter grows

Many SQL Server counter values   start at zero when a server starts and then grow persistently from there, including most of the values in the sysperfinfo system table. 

...