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.



Legal
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
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources