SQL Server Performance and Activity Monitoring issues

Redgate Monitor analyzes, plots, and tabulates its metric and alert data in various sections of the Redgate 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 Redgate Monitor
• Data points missing from the Analysis Graph in Redgate Monitor
• Global Overview doesn't display any details in your browser
• Issues caused by clock skew
• Resources section is empty

See also:

Redgate 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 Redgate 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 Redgate Monitor reveals and helps diagnose common causes of performance issues, such as long running queries, blocking, deadlocks, IO bottlenecks, indexing issues, and so on.