Versions Compared

Key

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

...

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

...

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. 

For example, the Buffer Manager Page Lookups/Sec counter in the value collected mode always shows the total number of page lookups since the server was first started, while when in the value per second mode, it shows the number of lookups per second during the monitored period.



SQL Diagnostics Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse