Maximize SQL Server monitoring with custom metrics

SQL Monitor’s custom metrics feature lets you run T-SQL queries against SQL Servers to collect specific data. But what if you don’t want to write your own queries? No problem. Red Gate has brought together a range of quality custom metrics for you to use in SQL Monitor.

Find

  • Browse popular metric categories or search for keywords or authors
  • Discover new and useful ways to monitor your SQL Servers
  • Decide quickly which metrics will broaden your monitoring range

Use

  • Automatically install a metric in your version of SQL Monitor
  • Tune settings specific to your environment by following our guidelines
  • Start collecting, analyzing and alerting on data right away

Share

  • Request a metric or write your own with help from Grant Fritchey’s article
  • Send your metric to us and we’ll test and review it for you
  • We’ll add it to this site and acknowledge you as the author

Job overran

by
VN:RO [1.9.17_1161]

This metric tells you whether a specific SQL Agent job that runs at exactly the same time every day has overrun its expected duration. Read more

Data not yet sent to the mirror

by
VN:RO [1.9.17_1161]

This metric tracks the amount of data waiting to be sent from the principal database to the mirror. This is known as the send queue. Read more

Current status of mirroring

by
VN:RO [1.9.17_1161]

Mirroring systems can go offline. This metric returns the current state of the mirroring system so you’ll know from a single value what the current status of your mirroring environment is. Read more