Resources

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

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)

Videos

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. In this video Grant talks about 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

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

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 5 (Released October 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

SQL Monitor 5.1 (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.2 (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 6 (October 2016)

  • Server overview redesign:
    • Introducing a groundbreaking diagnostic interface
    • Effortlessly 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
    • Find and solve the problem faster than with any other tool

Future (2016)

  • Increased sophistication of the alerting engine for more informative and actionable alerts
  • Support of new versions of Windows Server, SQL Server, Azure and major new browsers