Help

I want to know…

Which platforms and versions are supported?

How to install metrics automatically in SQL Monitor 3.2 or later

How to install metrics manually in SQL Monitor 3.0 and 3.1

Which settings need updating to get the metric working in my environment?

How to request or share a metric

I want to learn…

How to use a custom metric by following a walkthrough

How to write a custom metric by reading Grant Fritchey’s article

Which platforms and versions are supported?

Supported SQL Server versions

The custom metrics on this site will work on these SQL Server versions:

  • SQL Server 2005
  • SQL Server 2008
  • SQL Server 2012

The metrics below will also work on SQL Server 2000 SP4:

Supported SQL Monitor versions

Custom metrics can be used in SQL Monitor v3 or later.

Supported browsers for this site

This site works on:

  • Firefox 3 or later
  • Chrome 2 or later
  • Safari 5 or later
  • Opera 10 or later
  • IE 7 or later

How to install metrics automatically in SQL Monitor 3.2 and later

If you’re using SQL Monitor 3.2 or later, you can download metrics automatically.

Make sure cookies are enabled in your web browser so the site can remember the location of your SQL Monitor version, and enable automatic metric installation. If you arrived at this site directly from a link in SQL Monitor, you’ve installed cookies already. If you didn’t, go to the Configuration > Custom metrics page in SQL Monitor, and click on one of the links to sqlmonitormetrics.red-gate.com.

Once cookies are installed, find the metric you’re interested in on the site, and click the Install metric button near the top of the page:

This automatically populates a new Create custom metric wizard in SQL Monitor with the relevant metric settings.

Before creating the downloaded metric, review and update the settings that need changing to get the metric working in your environment. See Which settings need updating to get the metric working in my environment?

How to install metrics manually in SQL Monitor 3.0 and 3.1

If you’re using SQL Monitor 3.0 or 3.1, you’ll need to install metrics manually.

Go to the Configuration > Custom metrics page in SQL Monitor, and click the Create custom metric button. Now you can copy and paste text from the custom metric on the website to the blank wizard in SQL Monitor, and set options based on the original metric definition.

For more information on completing the wizard, see Red Gate’s Support Center.

Before creating the downloaded metric, review and update the settings that need changing to get the metric working in your environment. See Which settings need updating to get the metric working in my environment?

Which settings need updating to get the metric working in my environment?

Certain metrics contain settings that must be tuned to match your SQL Server environment before you can use them. You may need to:

  • add specific SQL Server object, database or job names to the T-SQL
  • select a specific instance to collect from
  • specify a named database to collect data from
  • change alert threshold settings that may be too high or too low for your SQL Server environment

If updates are necessary, notes are displayed on the example metric pages below the settings requiring attention:

Read through the notes and update the metric wizard settings in SQL Monitor as appropriate. For more information on completing the wizard, see Red Gate’s Support Center.

Once you’ve made the necessary changes, click through to the Summary page and click the Create metric or Create metric and alert button. The new metric is displayed on the Configuration > Custom metrics page.

If you want to edit the custom metric settings at any time, click on the metric in the Configuration > Custom metrics page to display the wizard. For more information about editing metrics, see Red Gate’s Support Center.

How to request or share a metric

If you’ve written a useful metric or you’ve got an idea for one, we’d like to hear about it. Use the Share page to send us your commented T-SQL or request, and add your contact details if you’d like us to get in touch. If we publish a metric written by you, we’ll acknowledge you as the author.