All alarms in Spotlight, including Diagnostic Server and operational alarms, can be configured.
The kinds of configuration include:
- Disable an alarm
- Set an alarm to require acknowledgment
- Configure keyed alarms - apply different severities to individual keys in an alarm.
- Change the severity level or number of severities. (Change severity information)
- Collect additional diagnostic information
- Do not alarm for certain values
Configure alarms from the Spotlight Client
Click Configure | Alarms.
Select template or connection to configure
Option | Description |
---|---|
Factory Settings | Select to show the standard settings shipped with Spotlight. These settings can be reapplied to a connection. These settings cannot be changed. |
Factory Reduced Sensitivity Template | Select to show reduced severity settings shipped with Spotlight. These settings reduce the severity of many alarms raised (compared to standard Factory Settings) and are more likely to raise a high severity alarm only where the situation presents an availability issue. These settings can be reapplied to a connection. These settings can be changed. |
Connection | Select a Spotlight connection to show / change alarm configurations for that connection. |
Template | Select a template to show / change / reapply a template configuration. Select a template to delete or rename that template. The templates you have previously saved are listed. For more information, see [Configuration templates][enterprise_cfgmonitor_templates]. |
Select an alarm to configure
The table of alarms is as follows.
Column | Description |
---|---|
Name | The name of the alarm. |
Type | The alarm applies to this connection type. |
Modified | Yes if the alarm is set to other than the Factory Settings. |
Double click on an alarm to [configure the alarm][enterprise_cfgmonitor_alarm].
Information about each alarm is documented under the connection type.
- Amazon RDS for SQL Server alarms
- Analysis Services alarms
- Availability Group alarms
- Azure SQL Managed Instance alarms
- Hyper-V alarms
- SQL Azure alarms
- SQL Server Replication alarms
- SQL Server alarms
- Spotlight Diagnostic Server alarms
- Unix/Linux alarms
- VMware alarms
- Windows Server alarms
Reuse this configuration
Apply configuration to…
Optionally, [apply this configuration][enterprise_cfgmonitor_applyconfig] to other connections.
Save to Template
Optionally, save this configuration to a template. Where a template has been selected to configure you will also see options to Delete or Rename the template. For more information, see [Configuration templates][enterprise_cfgmonitor_templates].
Close the dialog
OK
Save the alarm configuration(s) for the selected connection or template.
Cancel
Discard changes to this screen.
Alarm Template Report
The Alarm Template Report provides a list of user-defined alarm templates and the specific connections they are associated with. It also allows users to export the data in CSV format. The Alarm Template Report includes the following columns: Template Name, Connection Type, Connection Name, Connection Display Name, and Template Description. The alarm template applies to all the connection types that Spotlight Enterprise currently supports.
Behavior of Factory Reduced Sensitivity Template
The Factory Reduced Sensitivity Template is a non-default template that comes with the installation of the Spotlight application. Some alarms across all connection types—except MI and Amazon RDS are modified in this template. This template can be further modified, deleted, or renamed.
Since this template does not modify any alarms for MI and Amazon RDS connection types, applying it to those connections would have the same effect as applying the Factory Settings template. For this reason, the Factory Reduced Sensitivity Template can never be associated with MI or Amazon RDS connections, as it would not result in any non-default alarm configurations for those connection types.
Alarm Configuration Changes Report
The Alarm Configuration Changes Report displays details of modified alarms, including changes made to all monitored entities such as databases and operating systems. Users can export these changes in CSV format.
Changes made to the following fields or options will not be reflected in the Alarm Configuration Changes Report.
- Alarm Require Ack
- Severity (Key Value) - ADD
- Severity (Key Value) - Delete
- Collect additional diagnostic information
- Do not raise alarm for certain values