Versions Compared

Key

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

The Logs tab allows you view SQL Server SQL Server related logs. Use these logs to diagnose SQL Server SQL Server problems where a history of events is necessary to form context. The current log is selected by default but you can select archived or even multiple archived logs to view or search. Filter and Search options allow you to locate the areas of the logs that are most important.

Access the Logs tab

SQL Diagnostic Manager provides two paths to access the Logs tab. The first access path is Access this tab 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.server and selecting Servers>Logs.

Image Added

Available 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.

...

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 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.

...

Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|  
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
|  
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse