Monitoring status explained
Published 17 August 2020
SQL Monitor displays one of the following statuses on the Configuration > Monitored servers page for each host machine, cluster node or SQL Server instance:
Status | Displayed when | Suggested action |
---|---|---|
Monitoring (Connected) | All monitoring data is being collected successfully. | Click Show log and select All events to view all data collection events in the last five minutes. |
Monitoring stopped (Incorrect credentials or insufficient permissions) | SQL Monitor is currently unable to collect monitoring data because the credentials it is using have failed authentication. A Monitoring stopped ([host machine|SQL Server] credentials) alert is also raised. |
|
Unreachable (Cannot connect) | One of the following reasons applies:
|
|
Connection failed (Internal SQL Monitor error) | An unknown application error has occurred. If this problem occurs continuously for 2 minutes, a Monitoring error ([host machine|SQL Server] data collection) alert is also raised. | Please contact Red Gate support with information about your error, including relevant log file details. See: Viewing component information and log files. |
Connection failed (Bad data) | SQL Monitor cannot process some data collected from the host machine or cluster node. Possible reasons are:
| Click Show log and refer to the Exception and Exception message columns in the table of data collection events to determine the specific problem. |
Connection failed (Cannot connect) | One of the following reasons applies:
| SQL Monitor will automatically retry the connection every few minutes. Click Show log and refer to the Exception and Exception message columns in the table of data collection events for information about the type of problem. For more information, see: What to try if you hit connection problems. |
Unlicensed | Your evaluation period has expired and the machine, cluster node or SQL Server instance has not yet been licensed. | Enter a serial number or allocate licenses on the Configuration > Licensing page. One license is required for each host machine or cluster node – this will license all SQL Server instances on the machine or node. For more information, see: Licensing. |
Suspended | Monitoring on this machine, cluster node or SQL Server instance has been manually suspended. No data will be collected until you resume monitoring. | Go to the Configuration > Monitored servers page, click the Actions button at the end of the row and select Resume monitoring. For more information, see: Managing monitored servers. |
Maintenance window (Alerting suspended) | The host machine or node is currently in a maintenance window. SQL Monitor is still monitoring servers, but alerting is temporarily suspended. Once the maintenance window duration has ended, alerting will resume. | Go to the Configuration > Monitored servers page to check when the current maintenance window is due to end. For more information, see: Suppressing alerts. |
Viewing the connection events log
For some statuses, it is recommended that you check the log for more details. To do this, on the Configuration > Monitored servers page, click Show log for the server or instance experiencing connection problems:
The page contains a table listing recent errors or data collection events that can help you to determine the specific problem.