SQL Sentry Client Alerts

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 Alert IndicatorSQL Sentry Client Alert
Client Alerts WindowSQL Sentry Client Alerts window

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.

User Preferences System StatusThe following colors correspond to the different alert levels:

Alert LevelDescription
GreenA green status indicates that there are no alerts.
YellowA 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.
RedA 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.

Important:  To configure notifications for instance status and monitoring service errors, see the Failsafe Conditions topics.

Concerning the History Synchronization Failed Alert

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.

  1. 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.
    SSMS Configure Error Logs
  2. Uncheck Information, and then select OK to save.
    SSMS Configure SQL Server Agent Error Logs

Additional Information: For more information about SQL agent log synchronization issues, see the History Synchronization Failed article.