The client alert status indicator is in the bottom right hand corner of the SQL Sentry client. When an alert status is detected, a pop-up with information about the alert displays.
You may choose to:
- Pin the alert
- Dismiss it
- Open the Client Alerts window by selecting the alert text
Client alerts are designed to provide actionable information about problems in your monitored environment. To open the Client Alerts window, double-click the status indicator in the bottom right hand of the screen.
You may disable status alert pop-ups or change the recurrence interval through Tools > User Preferences > System Status.
The following colors correspond to the different alert levels:
|Green||A green status indicates that there are no alerts.|
|Yellow||A yellow status is the warning level indicator. Warning level alerts are generated when there is a problem that limits the full functionality of SQL Sentry. This could include the SQL Server agent being offline.|
|Red||A red status is the error level indicator. Error level alerts are generated when there is a significant problem in your monitored environment, such as when an instance has been detected as offline, or if there is a problem synchronizing data.|
History Synchronization Failed: Message: SQL Server Agent has information logging turned on. The log will fill quickly in this state. Agent log history synchronization will be paused until information logging is turned off.
This error message indicates that information logging is enabled for the SQL Server Agent Log. With this level of logging enabled, the agent log quickly grows beyond one megabyte in size. The overhead associated with reading the SQL Server Agent Log when it grows to this size can cause performance problems. SQL Sentry doesn't synchronize the agent log until information logging is disabled.
Information logging can be turned off by completing the following steps.
- From SSMS (SQL Server Management Studio), right-click the Error Logs folder within the SQL Server agent group node for the associated server, and then select Configure.
- Uncheck Information, and then select OK to save.