Working the grid
List of current and archived error logs
Use this list to choose the error log whose details you want to view in the Error Log grid below.
By default, Spotlight Enterprise retrieves the first log in the list above the grid, if the log is less than 1MB in size. If the log is larger than 1MB, Spotlight will not retrieve it unless you click Refresh. Retrieving large error logs can impose significant load on the server.
Refresh
Click Refresh to view the error log selected in the list.
Max records
For performance reasons, Spotlight Enterprise limits the number of records that can be viewed in this page. By default, it will show the last 500 records that have been logged. To change the number of records, enter a value in the Max Records field above the SQL Server Error Log grid and then click Refresh.
Cycle
Click Cycle to archive the current error log file and open a new log file. Your oldest log file may be deleted. Only members of the Spotlight Diagnostic Administrators group can use the Cycle option.
Error Log Scanning
Click Error Log Scanning to define and edit the alert rules that Spotlight scans the SQL Server Error Log for.
Error Log grid
This displays details of the errors logged in the file chosen via the list at the top of the page. The columns in the grid are:
Date/Time
The date and time that the specified error was logged.
Process Info
The source of the entry in the error log.
Message
A brief description of the error.