Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

SQL Diagnostic Manager provides two paths to access the Logs tab. The first access path is by clicking the appropriate monitored SQL Server instance, and then clicking the Logs tab. The second access path is by expanding the Servers tree, and then clicking Logs for the appropriate instance.

Available actions

  Actions

Click Cycle Server Log to archive the information in the most recent log and start a new log. 

Click Configure to determine the number of SQL Server logs retained by SQL Server. 

Details section

The Details section provides more information for the selected event.

Filter

The Filter options allow you to return specific data. Note that these selections work only once you enable log alerts.

Logs tab

The Logs tab allows you to look at all the events taking place on your SQL Server instance. Each event, when selected, contains detailed information in the Details section of the tab which allows you to diagnose specific issues that occur.

...

For Example : if one of your SQL Server instances restarts, the event log can tell you the time of the restart. This helps you diagnose issues that occur on your SQL Server instances.

The Search feature allows you to find information based on text available in the message, message number, or source.

 

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