Red Gate logo

Real-time SQL Server performance monitoring, with alerts and diagnostics

Download free trial

An introduction to SQL Monitor

Monitoring the activity and performance of SQL Server and resolving problems is time-consuming.

That's where SQL Monitor steps in with clear insights into SQL Server performance in real time, bringing problems to your attention before anyone else notices.

With its embedded expertise from SQL Server experts and MVPs, it gives you the data and advice you need to find and fix issues before users are even aware.

So, whether you're looking for baselining, wait stats, expensive queries, or instant alerts, find out how SQL Monitor gives you everything you need – and more – with a free 14 day trial.

Download free 14 day trial

Pricing information

$1,495

per server

Buy now

Buy 10 or more licenses for a 50% discount

$7,475

10 licenses with a 50% saving

Buy now

Professional, web-based monitoring, built with advice from experts

We consulted over 1000 SQL Server professionals to ensure SQL Monitor is simple to install, easy to use, and provides the data you need before making tough calls about SQL Server performance.

Out of the box, you can improve your SQL Server monitoring in six key ways

alert-inbox

Receive instant alerts on performance issues

SQL Monitor raises alerts within 15 seconds of a problem or performance issue occurring. They arrive in a shared Alert Inbox, and you can pick them up by email or use PagerDuty for SMS.

See feature in online demo

Understand bottlenecks with wait stats

Identify performance bottlenecks using wait stats, and get expert advice on how to diagnose and fix any problems. You can also check which queries are most affected by these waits.

See feature in online demo

View the top ten expensive queries

For each database and server, SQL Monitor highlights the queries that use the most resources. You can use the execution plan and waits of each query to understand its performance.

See feature in online demo

Automatically plot baselines

Spot unusual performance, automatically plot baselines, and review trends over time, for a better understanding of typical server performance and the causes of any recurring issues.

See feature in online demo

Add a range of custom metrics

SQL Monitor has a library of custom metrics written by SQL Server experts. You can import them with one click to extend what you monitor – or write your own custom metrics in T-SQL.

See feature in online demo

Access embedded expertise

SQL Monitor's alerts and metrics were selected on the advice of SQL Server experts and MVPs. You see only the information that matters, alongside expert advice on how to make use of it.

See feature in online demo

“It's very simple to use and doesn't drown me in unnecessary information. It came out on top for being reasonably priced and also functionality. I see issues well before the user, and can stop them in their tracks. We now have a stable SQL estate due to SQL Monitor.”

Nic Hopper,
Senior DBA,
Atrium Underwriters Ltd.

SQL Server performance monitoring at work

SQL Monitor gives you information fast. It also gives you information in-depth, if you need it.

Here's how you can get the most out of SQL Monitor with baselining, SSRS reporting, and custom metrics.

Baselining

Is your server behaving normally?

SQL Monitor shows you at a glance...

When you see performance spikes in SQL Server, how do you know if you're looking at a problem or something within the range of normal behavior?

Looking at past performance data is often not enough. Ideally, you want a baseline, so you can measure your performance data against what's normal for that specific server.

SQL Monitor calculates and displays baselines for you automatically, using the performance data that it already records.

Without any extra work to gather the data, you can check a baseline for CPU, memory, and whatever else you need on each server.

SQL Monitor takes the latest performance data into account, so you're always looking at real life performance, not a baseline that's tied to a single period in the past.


See how metrics vary over time

To get a simple baseline, you can compare a metric with its performance last week, or at any period you know was normal. The two appear side by side on the same graph.

For a full overview, you can extend this baseline to cover multiple periods, such as the last seven weeks, or the last 10 Fridays at 3-4am.

If you want to get a feel for a metric — how and when it spikes, how it's changing over time — you can view each baseline period as a separate line, making it easier to spot gradual or drastic shifts.

metrics-vary-over-time

Check if performance spikes are within expected behavior

When you need to see the range of expected behavior, SQL Monitor can combine your baselines into regions. The dark inner region shows you where the metric falls most of the time. The outer region shows the full range.

It's a handy way to see the shape and spread of your data, so you can look past the noise without the flattening and distortion that comes from a simple average.


Investigate problems with pan-and-zoom performance graphs

To spot correlations between performance spikes and see what's going on inside your servers, you can compare multiple metrics on a single performance graph.

The graphs pan and zoom, so you can drag them back and forward in time, or zero-in on hotspots, to get right to the root of performance problems.


Try it out with data from SQLServerCentral

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, SQLMonitorMetrics.com, 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 sqlmonitormetrics.red-gate.com


Possible duplicate indexes by Fabiano Amorim

When a table has multiple indexes defined on the same columns, it produces duplicate indexes that waste space and have a negative impact on performance.

Read more or install this script from sqlmonitormetrics.red-gate.com

Case Studies: SQL Monitor in action

Case study

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)

Case study

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)

Case study

Geeks with … SQL Monitor

Geekswithblogs.net 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)

Case study

How to handle 25 million database changes a day

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

Read the case study (PDF)

grant-circle

Videos

Grant Fritchey on deadlocks, customizing alerts, and wait stats

SQL Server MVP Grant Fritchey explains how monitoring can improve your servers' performance in three key ways

He covers how to use wait stats to spot slow behavior on your server and track down the causes, how to capture and understand deadlocks, and how to extend your monitoring with custom alerts.

Watch the videos

The DBA Team

Not long ago, a crack team of SQL Server experts was flamed for a crime against database normalization they didn't commit. These men promptly escaped from the taunts of academic relational theorists.

Today, they survive as website editors and software evangelists. If you have a problem, if no one else can help, and if you can find them, maybe you can hire the DBA Team.

Check out their latest adventure