The Filter Settings window allows you to select:

  • The time range to filter events, such as Date Range-Begin and Date Range-End.
  • The source of the log entry, such as the session ID number.
  • The message severity, such as OK, Warning, or Critical.

If the alert is disabled, all messages are informational.

Access the Filter Settings window

To open the Filter Settings window from the SQL Diagnostic Manager Logs tab, select the appropriate SQL Server instance, click Logs, and select Filter.

Settings Server Log filters

To Filter the Server Log:

  1. Click the Filter button on the Logs tab.
  2. Verify that SQL Diagnostic Manager displays the correct Source.
  3. Make the necessary changes in the Message Severity area.
  4. Type a Date Range-Begin and Date Range-End in the Period section of the Filter Settings window.
  5. Click OK.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >