Product articles SQL Monitor Monitoring Large Estates
The Underground Map of SQL…

27 April 2020
27 April 2020

The Underground Map of SQL Monitor

The "metro map" of SQL Monitor, with sightseeing tips and essential stops along every line....

Original concept and design: Phil Factor.

Download the Map as a PDF wallchartUndergroundMapOfSQLMonitor

Highlights of Monitor Town

Sightseeing tips and essential stops along every line….

The Configuration “line” of SQL Monitor is where you go to manage monitored servers and SQL monitor users, to configure, customize and automate your monitoring and alerting strategy, for each server, manage your licenses, investigate errors and more.

Download the Configuration Map as a PDF: MonitorConfiguration

Time spent exploring the Estate line will help DBAs to monitor and safeguard the security, stability and availability of all servers in their care.

Download the Estate Map as a PDF: Estate

Stop off at Reports to create, configure and schedule reports to share with others in your organization.

Download the Reports Map as a PDF: Reports

Any metric sparkline in SQL Monitor provides a connection over to the Analysis page, where you can plot graphs showing the behavior of a group of metrics, around the time of slow performance, or a specific problem.  This will help you expose the root cause of common bottlenecks, spot worrying trends, or patterns of failure around certain times.

Download the Analysis Map as a PDF: Analysis

Teams will visit the Alerts Inbox most days, in order to investigate and resolve problems that arise on any SQL Server. These might include: resource bottlenecks (CPU, memory or I/O issues); disk space warnings;  failed backups and other scheduled jobs; slow performance, such as caused by ‘blocking’ or other other query problems; specific SQL Server errors, such as deadlocks. The Alert Details provide specialist diagnostics for each alert type and the Performance data for each alert tell you what was happening on the server and instance during and around the time the alert was raised.

Download the Alerts Map as a PDF: Alerts

The Overviews line is to SQL Monitor what the Central line is to London or the A-train to New York City. It is where you can review any problems that arise, directly within the context of server activity over that period.

The Metrics branch of the Overview line…

The processes and databases branches of Overviews…

Download the Overviews Map as a PDF: Overviews

You may also like

  • Webinar

    7 steps to effective SQL Server monitoring

    Knowing what’s happening on your servers is vital to ensuring business continuity. We’ll show you the best way to set up monitoring on your environment, and how Redgate SQL Monitor provides a powerful and fast way of achieving this.

  • Webinar

    The State of SQL Server Monitoring 2019

    Join Microsoft MVP’s Grant Fritchey and Chris Yates, alongside Annette Allen, Database Architect at University of Exeter and Tony Maddonna, Microsoft Platform Lead & SQL Server Enterprise Architect at BMW Manufacturing, as they discuss the key findings of Redgate’s 2019 State of SQL Server Monitoring survey.

  • Article

    Q&A from our recent ‘What’s New in SQL Toolbelt’ webinar

    I recently gave a Redgate University webinar with Chris Kerswell and Thomas Walsh. Giving webinars as a team is terrific, as it shows how we work at Redgate. Chris is a Sales Engineer, Tom is a Software Engineer, and I’m a DevOps Advocate. Behind the scenes, we often work together across these groups to solve

  • Webinar

    Diagnose issues within your SQL Server Estate in the era of Connected Health

    SQL Server Monitoring is critical to quick detection of performance issues that can jeopardize database availability. However, it's not enough to simply know there is a performance issue. You also need to be able to pinpoint the root cause and know exactly where to find it.

  • Forums

    SQL Monitor Forum

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