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. 

...

The archive number is the file number associated with the log in SQL Server while the date is the last modified date of the file on disk. If the archive numbers seem out of order, check the error log.

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.

...