Resources

Case studies

“SQL Monitor doesn’t just benefit Claranet, it benefits our customers too”

Managed IT services provider Claranet, switched to SQL Monitor to cover their large SQL Server estate when they were having issues with their old SQL Server monitoring tool. SQL Monitor now helps them deliver more with less.

Read the case study (PDF)

“How SQL Monitor changed the culture of Mamas & Papas and made work more enjoyable and productive”

When UK-based retailer and manufacturer Mama & Papas found that their in-house SQL Server monitoring system wasn’t up to the job, and was also creating more work for them, they turned to SQL Monitor and dramatically changed the way they work.

Read the case study (PDF)

“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

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)

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)

What's New in SQL Monitor 7

Redgate’s Jake Sigrist talks you through the new reporting module in SQL Monitor V7. The module allows you to view reports on your entire SQL Server estate as well as creating custom reports for individual servers/instances.

How to quickly diagnose the root cause of SQL Server problems with SQL Monitor

In this session Grant Fritchey describes how SQL Monitor can make diagnosing SQL Server problems quicker and easier.

SQL Monitor Overview Webinar

SQL Server Monitoring Specialist James King takes you from getting a simple overview of your entire SQL Server estate to alerting and diagnosis of SQL Server problems.

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.

Setting up and customizing 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.

How to check and compare baselines with SQL Monitor

SQL Monitor’s Anne Edwards explains how to check baselines for SQL Server performance metrics in Redgate SQL Monitor.

Availability Group Monitoring in SQL Monitor

Grant Fritchey shows you how to easily monitor your AlwaysOn Availability Groups using Redgate’s SQL Monitor. See instantly how your replicas are performing and if, in the result of a failover, your Availability Groups are in the correct state to keep your service running.

Adding custom metrics from SQLMonitorMetrics.com

SQL Monitor’s Anne Edwards covers how to set up pre-written custom metrics for SQL Server from sqlmonitormetrics.red-gate.com in SQL Monitor.

How to create your own custom SQL Server metrics in SQL Monitor

SQL Monitor’s Anne Edwards shows you how to set up a new custom SQL Server metric in SQL Monitor. She covers entering T-SQL code, choosing SQL Server instances to monitor, data collection frequency, and more.

Capturing and understanding deadlocks

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

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.

Articles

  • The Strategic Value of Monitoring SQL Server

    Why do you need to automatically monitor the SQL Servers in your care? What's the business value? What features should you look for in a performance-monitoring tool? In this free nine-page guide, SQL Server MVP Rodney Landrum gives you the answers.

    Read more

  • Five signs you need a SQL Server monitoring tool

    Working with SQL Server? Here are five signs that a tool could make your job easier, your life simpler, and work less stressful. Read them now.

    Read more

  • Defrosting frozen screens: troubleshooting SQL Server blocking problems

    Locking and blocking is a normal and required activity in SQL Server. However, if we execute long, complex transactions that read lots of data, and take a long time to execute, then locks will be held for extended periods, and blocking can become a problem.

    Read more

  • How to never lose track of SQL Server disk space

    Running out of disk space on a server can cause work to grind to a halt, and be extremely embarrassing for the system administrator. The goal is to avoid this type of issue altogether, via proactive monitoring.

    Read more

  • Resolving SQL Server Disk IO bottlenecks

    Using any single metric will often lead to an incorrect diagnosis of a problem. By reviewing all relevant performance metrics as a unit, we have the best chance of choosing the most effective course of action.

    Read more

  • Tracking SQL Server Agent Job Duration

    We need to know not only when jobs fail, but also when they display uncharacteristic behavior. We need a way to track SQL Server Agent job duration over time, and be alerted to anomalies.

    Read more

  • 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, 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


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