SQL Monitor analyzes, plots, and tabulates its metric and alert data in various sections of the SQL Monitor Web Interface. It tries to make it as easy as possible for you to use this data identify the root cause of problems on your SQL Servers, understand the performance patterns that your instances and databases exhibit when under load, and review trends, anomalies and errors.
This section covers a few known causes of missing for conflicting data reported in its graphs, and links to other resources that provide answers to some common requests and queries.
Reported errors or problems:
- Different values displayed for the same data points on the Analysis Graph in SQL Monitor
- Data points missing from the Analysis Graph in SQL Monitor
- Global Overview doesn't display any details in your browser
- Issues caused by clock skew
- Resources section is empty
SQL Monitor documentation.
- Performance diagnostics: queries and waits
How to corroborate wait statistics, query statistics and SQL Server resource use over a period.
- What is included in the "SQL User Processes (Top 10)" table on the Server overview
Information from sysprocesses identifying each user process, the program that issued it, and the CPU and IO resources it used.
- Navigating SQL Monitor's Global Dashboard
A single summary view of all monitored SQL Server instances, wherever and however they are hosted.
- The cluster and availability group overview pages
Metric and alert status for all nodes in the cluster, SQL Server instances running on the cluster, and Availability Groups.
Product articles (Redgate Hub):
- SQL Server Performance Monitoring
Articles describing how SQL Monitor reveals and helps diagnose common causes of performance issues, such as long running queries, blocking, deadlocks, IO bottlenecks, indexing issues, and so on.