Use the Spotlight Cloud Diagnostic Server application
Open the Spotlight Cloud Diagnostic Server application. You will find the application on the desktop of the computer where Spotlight Cloud is installed. Double click on the desktop icon.
Sign in with your Quest account.
The configuration panel opens. Click Error Log.
The configure error log entries dialog opens.
Select template or connection to configure
Select a SQL Server connection from the list of available options. On selecting the connection you can view / modify the configuration. When done you can use the options at the bottom of the screen to apply this same configuration to other SQL Server connections or save the configuration as a template.
Alternatively select one of the Spotlight Cloud error log entries configuration templates you have previously saved. On selecting the template you can view / modify / reapply the template configuration. You can delete or rename the template. For more information, see configuration templates.
Override or use the factory settings
Select the Override the factory settings option to modify the settings for the selected template or connection.
When you clear the Override the factory settings option you return the settings for the selected template or connection to the Factory Settings. These are the settings that were shipped with Spotlight Cloud.
Enable error log scanning
By default this option is selected and Spotlight Cloud scans the SQL Server error logs. Clear the Enable error log scanning option to stop Spotlight Cloud from scanning the SQL Server error logs.
Match List
For each row on the Match List - If Enabled is selected then Spotlight Cloud scans the SQL Server error log for the given Log Entry. If found then the log entry will be tabled in the error log drilldown. Additionally, if Raise Alarm is selected then Spotlight Cloud will raise an alarm of the severity in the Sev column. See more on SQL Server alarms.
Default settings for the match list
| Enabled | Sev | Log entries | Raise alarm | Alarm raised |
|---|---|---|---|---|
| Yes | Medium | Severity: 17 | Yes | SQL Server Fatal Table Integrity Suspect Error (severity level 22) |
| Yes | Medium | Severity: 18 | Yes | SQL Server Fatal Database Integrity Suspect Error (severity level 23) |
| Yes | Medium | Severity: 19 | Yes | SQL Server Fatal Hardware Error (severity level 24) |
| Yes | High | Severity: 20 | Yes | SQL Server Fatal Hardware Error (severity level 25) |
| Yes | High | Severity: 21 | Yes | SQL Server Low Severity Error Log Message |
| Yes | High | Severity: 22 | Yes | SQL Server Low Severity Error Log Message |
| Yes | High | Severity: 23 | Yes | SQL Server Low Severity Error Log Message |
| Yes | High | Severity: 24 | Yes | SQL Server Low Severity Error Log Message |
| Yes | High | Severity: 25 | Yes | SQL Server Low Severity Error Log Message |
| Yes | Low | Backup Failed | No | SQL Server Low Severity Error Log Message |
| Yes | Low | SqlDumpExceptionHandler | No | SQL Server Low Severity Error Log Message |
| Yes | Low | TABLE corrupt | No | SQL Server Low Severity Error Log Message |
| Yes | Low | admin | No | SQL Server Low Severity Error Log Message |
| Yes | Low | cannot obtain a LOCK | No | SQL Server Low Severity Error Log Message |
| Yes | Low | Error | No | SQL Server Low Severity Error Log Message |
| Yes | Low | Victim Resource | No | SQL Server Low Severity Error Log Message |
| Yes | Low | Expire | No | SQL Server Low Severity Error Log Message |
| Yes | Low | stack | No | SQL Server Low Severity Error Log Message |
| Yes | Low | is full | No | SQL Server Low Severity Error Log Message |
| Yes | Low | cannot | No | SQL Server Low Severity Error Log Message |
| Yes | Low | hung | No | SQL Server Low Severity Error Log Message |
| Yes | Low | WARNING | No | SQL Server Low Severity Error Log Message |
| Yes | Low | Unable | No | SQL Server Low Severity Error Log Message |
| Yes | Low | Could not allocate new page | No | SQL Server Low Severity Error Log Message |
| Yes | Low | attempting to unlock unowned | No | SQL Server Low Severity Error Log Message |
| Yes | Low | failed | No | SQL Server Low Severity Error Log Message |
Changing the match list
Providing the Override the factory settings option is selected above, you can modify entries tabled on the Match List.
Enabled
An entry must be Enabled for Spotlight Cloud to scan the SQL Server error logs for it.
Add / Edit
Click Add to add an entry to the Match list. Click Edit to modify the selected entry on the Match list.
For the Error Log Entry text do not use the | character as Spotlight Cloud uses this character to mark the end of the string.
Copy
Make a copy of the selected entry on the match list.
Delete
Remove the selected entry from the match list.
Enable all / disable all
Click Enable All to enable all entries on the match list. Click Disable All to disable all entries on the match list.
Raise alarm
When Raise alarm is selected, Spotlight Cloud will raise an alarm when the SQL Server error log entry is found. Note that you will not be able to select the Raise alarm option while the Enabled option is not selected.
Ignore list
Spotlight Cloud will not raise an alarm for error log entries that are matched by at least one entry on the Ignore list. Use the Ignore list to define cases where error log entries matched (from the match list) should be ignored by Spotlight Cloud.
Default string entries in the ignore list
- Login
- START_FAILED
- ANSI_WARNINGS
Reuse this configuration
Apply configuration to…
Optionally, apply this configuration to other connections. See apply configuration to….
Save to template
Optionally, save this configuration as a template. Where a template has been selected to configure you will also see options to Delete or Rename the template. For more information on templates, see configuration templates.