Bild von SQL Monitor

SQL Monitor

Überwachen Sie die Leistung Ihrer SQL Server in Echtzeit

SQL Monitor

SQL Monitor stellt die Leistung Ihres SQL-Servers in Echtzeit auf einer webbasierten Benutzeroberfläche dar, sodass Sie den Zustand Ihrer Datenbanken jederzeit überprüfen können. Mit dem Tool erkennen Sie Probleme, bevor diese jemand anderem auffallen.

Integrierte Leistungsanalysen, eine Liste der zehn aufwendigsten Abfragen, automatisches Baselining und die Möglichkeit zum Hinzufügen eigener Überwachungsmetriken lassen keine Administratorwünsche offen.

SQL Server performance monitoring at work


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.

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.

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

Custom metrics

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.