Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

SQL Server | Error Log Drilldown

The SQL Error Log drilldown provides access to both the SQL Server Error Log and the SQL Server Agent Error Log.

By default, Spotlight 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.

To see the Error Log drilldown

  1. Select a SQL Server from Monitored connections.
  2. Click Monitor | Error Log.

Show all

To investigate... Look at the...
SQL Server Error logs SQL Server Error Logs page
SQL Agent Error logs SQL Agent Error Logs page

TIP: For general information on how to use Spotlight grids, see Spotlight grids



  • To display the current contents of the SQL Server error log, click Refresh.

  • To view an archived error log, select the log from the list and click Refresh.

  • For performance reasons, Spotlight limits the number of records that can be viewed in this drilldown. By default, it will show the last 500 records that have been logged. To change the number of records:

    1. Click Filter.

    2. Enter a value in the Max Records field.
    3. Click Refresh.

  • The SQL Server Error Logs grid displays the contents of the error log selected in the list above the grid. As this is a snapshot of the selected error log it is not updated automatically.
  • Click Cycle to archive the current error log file and open a new log file. The oldest log file may be deleted. Only members of the Spotlight Diagnostic Administrators group can use the Cycle Error Log option.

  • To define and edit the alert rules that Spotlight scans the SQL Server Error Log for, click Error Log Entries.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating