Maximize SQL Server monitoring with custom metrics

SQL Monitor is a performance monitoring and alerting tool for
SQL Server, with a web-based UI. Its 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.


  • 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


  • 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


Percentage of fragmented indexes

VN:RO [1.9.17_1161]

This is a general indicator of performance problems. Index fragmentation can affect the rate of return for moderate to large tables. If multiple indexes are fragmented throughout the database, then an index maintenance strategy needs to be evaluated. Read more

Identity columns near limit

VN:RO [1.9.17_1161]

If your application relies on identity columns, use this metric to measure the number of identity columns that are near to the limit per database. Read more