Case studies

“SQL Monitor now makes the team look more professional”

Find out why Prudential plc, an international financial services group responsible for £505 billion in assets, relies on SQL Monitor to check historical issues, catch performance problems, and monitor the activity of over 100 SQL Servers.

Read the case study (PDF)

How Digital Outsource Services catch deployment problems and save 15 hours a week

When digital marketing and customer relationship management agency Digital Outsource Services switched to SQL Monitor to monitor 24 production servers, they saved 15 hours a week. Theresa Boonzaaier, Senior DBA, tells you how in this case study.

Read the case study (PDF)

Using SQL Monitor at Interactive Intelligence to save up to six hours of work each day

Business communications software company Interactive Intelligence have tracked their SQL Servers with SQL Monitor since 2011. Now their IT team is alerted to SQL Server problems before they impact customers. See how they do it in this case study.

Read the case study (PDF)

Geeks with … SQL Monitor use SQL Monitor to keep their servers running smoothly for their users around the world.

They use SQL Monitor to help look after server performance, determine why certain issues occur, and get daily statistics on blogger registration and content production.

Read the case study (PDF)

How to handle 25 million database changes a day

Find out how Monsoon Commerce use SQL Monitor to track the databases that power, an online marketplace of more than 150 million items.

Read the case study (PDF)


How to install SQL Monitor

See how to get up and running with SQL Monitor in 5 minutes and start monitoring your SQL Servers. This step-by-step guide shows you in real-time how simple and quick the installation process is.

Watch fullscreen video

Webinar: the importance of wait statistics in monitoring SQL Server

In this webinar, Grant Fritchey explains where wait statistics come from, why you should care, and why they are so important for troubleshooting SQL Server.

Watch fullscreen video

Setting up custom alerts in SQL Monitor

Getting SQL Server monitoring in place is great, but to really make it pay off, you need to take the time and trouble to customize your alerts. Find out why you should do this and how to get the job done with SQL Monitor.

Watch fullscreen video

Capturing and understanding deadlocks

Grant Fritchey tells you how deadlocks can be captured and understood using SQL Monitor.

Watch fullscreen video


  • What changed on my SQL Server instance?

    Let's say a user reports that the performance on their application seemed slower than normal that morning. Was it? And if so, what changed? These are hard questions to answer, unless you have baselines to compare against.

    Read more

  • SQL Server Performance Troubleshooting with SQL Monitor 5

    Any SQL Server monitoring tool must gather the metrics that will allow a DBA to diagnose CPU, memory or I/O issues on their SQL Servers. It should also provide a set of accurate, reliable, configurable alerts that will inform the DBA of any abnormal or undesirable conditions and properties, as well as specific errors, on any of the monitored servers.

    Tony Davis and Grant Fritchey provide an in-depth guide to the monitoring and alerting functionality available in one such tool, Redgate SQL Monitor.

    Read more

  • SQL Server AlwaysOn Availability Group Monitoring with SQL Monitor

    "Managing SQL Server Availability Groups is a bit like spinning plates. But with a good monitoring tool you can see at a glance the status of an Availability Group as a whole, and then go deeper into each replica and database.

    "Suddenly, you no longer need to spin plates."

    Read more

SSRS reporting

Free SQL Monitor SSRS Reporting Pack

The SQL Monitor Reporting Services Pack is a series of SSRS reports for servers and databases monitored by SQL Monitor. It provides handy examples of the types of reports you can generate from SQL Monitor's data repository.

The pack is available as a free download and includes these reports:

  1. SQL Agent Job Summary.rdl
    Summarizes the jobs that have run on each server and shows their completion status
  2. HDD Usage Summary.rdl
    Simple overview of disk usage
  3. Memory Usage Summary.rdl
    Simple overview of the RAM used by host machines over time
  4. SQL Server CPU.rdl
    Shows SQL Server CPU% utilization over a configurable time period
  5. DB Size.rdl
    Shows database size over a configurable time period for a given database
  6. Server Info.rdl
    Shows general information about all host machines and SQL Server instances
  7. Top DBs by Growth.rdl
    Lists the fastest-growing databases
  8. Top DBs by Size.rdl
    Lists the largest databases
  9. Alerts.rdl
    List the number of alerts by server and/or alert type

Details of how to install and use the pack are included in the download.

Download SSRS pack

NOTE: this pack includes a set of example reports, to show how SSRS reporting can work with SQL Monitor. It is not part of the core product and, consequently, is not supported.

3. Memory Usage Summary: a simple overview of RAM usage
9. Alerts: lists the number of alerts by server and/or alert type
6. Server Info: general info on host machines and SQL Server instances

Custom metrics

If you want SQL Monitor to collect extra performance data that's particularly important for your servers, you can now add T-SQL scripts to do it.

You can analyze this data and receive alerts about it just like any other data that SQL Monitor collects.

On our dedicated custom metrics site,, you can find and review T-SQL scripts and import them directly into your copy of SQL Monitor.

MVPs, the SQL Monitor team, MVPs, and the SQL Server community have added scripts to the site. You can access it straight from SQL Monitor.

If you run applications that store data in SQL Server, you can use custom metrics to monitor and alert on the data they collect, so you can now use SQL Monitor to track business activity, too.

Get started with our custom metric walkthrough

Installing a metric and getting it working in SQL Monitor is easy, and we've provided a short walkthrough to guide you through the process. By the end of it, you'll have installed a custom metric that monitors whether specific backup jobs have been disabled.

Read more or install this script from

Table size (MB)
by the SQL Monitor Team

This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes.

Read more or install this script from

SQL Monitor Roadmap

Below are the major milestone releases we have planned. Small improvements, tweaks and bug fixes will be continuously delivered at the end of each development team sprint.

Note: The world of SQL Server is changing all the time: we may change our plans to accommodate for new innovations. To keep SQL Monitor a reliable and secure product, delays may occur.

SQL Monitor 6 (Estimated release Q3 2016)

  • Server/instance overview redesign:
    • Introducing a new diagnostic interface to quickly determine the root cause of a performance issue
    • Find out when a problem started, what went wrong, and what led to things going wrong, even after the fact
  • Ability to view query execution plan for top queries
  • Better integration of SQL Monitor alerts with other third party systems e.g. Slack via SNMP traps

Future (2016)

  • Improvements to reporting feature which will support designing your own report, and defining schedule to email those reports out.
  • Alert improvements such as more granular control over Deadlock alert
  • Improvements to Maintenance windows
  • Improved VM host monitoring
  • More performance and scalability enhancements

SQL Monitor 5.2 (Released Q2 2016)

  • New Dashboard:
    • See the current state of your entire environment at a glance
    • Quickly identify systems that are in trouble, drill down to find out what’s going on
    • Easily add new servers
  • Windows Server 2016 support

SQL Monitor 5.1 (Released Q1 2016)

  • Significant performance improvements: Reliably monitor 100s of servers from a single installation
  • More actionable operational alerts: Improved behavior to eliminate false positives
  • Azure, Amazon EC2 support (IaaS)

SQL Monitor 5 (Released Q4 2015)

  • Additional support for monitoring AlwaysOn Availability groups:
    • Availability Groups are monitored as part of their host clusters
    • Availability Group specific performance metrics
    • Availability Group specific operational alerts
    • Availability Group Overview screen
  • SQL Server 2016 support
  • Log into SQL Monitor with your Active Directory credentials
    • Set which Active Directory users can access which monitored servers
  • Visual improvements to the UI
  • Stability bug fixes: Improved Reliability of Monitoring Process