SQL Server Error Log (Error Log)
An MSSQL_SERVER_ERRORLOG (Error Log) application is a functional application that provides specific parameters, menu commands, and InfoBox items pertaining to the SQL error log or SQL Agent error log that the instance represents. Error Log application instances are created for each SQL Server instance, one for the SQL Server Error Log and another for the SQL Agent Error Log, and the names SQLErrorLog and SQLAgentLog appear under those instances, respectively.
The SQL Agent Error Log appears only when SQL Agent monitoring is enabled. To enable SQL Agent monitoring, see Monitoring-SQL-Server-Agent. Also, you must have Monitor SQL Server Error log and Monitor SQL Server Agent Error log selected in the Monitoring Setup dialog box. To access the Error Log application instances, double-click the Server application icon.
Application class attributes
Item | Description |
|---|---|
Active | Yes |
Created by | Discovery |
Parent class | |
Child class | None |
InfoBox
The following information is displayed on the Error Log InfoBox:
InfoBox Item | Description |
|---|---|
SQL Server Name | Name of the SQL Server |
Error Log File | Directory path to the error log or SQL Agent.out file |
Error Log Type | Name of the SQL Server and type of error log monitored by this Error Log application instance:
|
Last Updated | Day, date, time, and year when this InfoBox was last updated |
Error Log Size | Size in megabytes of the current error log |
Error Log Size Threshold | Threshold for the size of the error log, as defined by using the Setup Error Log Size Threshold menu command |
Error Log Size Threshold Exceeded | Indicates whether the current error log exceeds the Error Log Size Threshold |
Free Disk Space Remaining on | Amount of free disk space remaining on the disk that contains the error log |
Free Disk Space Remaining Threshold | Indicates whether or not the the amount of free disk space on the disk drive that contains the error log has fallen below the user-defined threshold (X). Valid values are as follows:
|
Error Log Collector Value | Displays the current numeric value for the ErrorLogColl collector parameter (0, 1, 2, or 3) or N/A if the ErrorLogColl parameter is not available. |
Extra Diagnostic Information | Displays the error number and a description of the error when an error is detected by the ErrorLogColl collector parameter |
Attributes (parameters)
The following attributes are available for this monitor type: