Chat now with support
Chat with Support

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

Connection Properties | Monitoring

Open this screen from the Spotlight Client

  1. Click Configure | Connections.

  2. Right-click the connection and select Properties | Monitoring.

Select monitoring options

Option Description

Monitor this server

Selected

Monitor this connection.

Not Selected

Do not monitor this connection.

No new data is collected and therefore no alarms are raised. Existing data in the Playback Database and Spotlight Statistics Repository is preserved.

Alarms

Configure the alarm settings. For more information, see Configure | Alarms.

Schedules

Customize how often data is collected. For more information, see Configure | Scheduling.

Error Log Entries

Request Spotlight raise an alarm when certain SQL error log entries are logged. For more information, see Configure | Error Log Entries.

SQL Server Response Time

Set the SQL statement that is used to measure SQL Server response time.

The response time itself can be viewed in the SQL Server | SQL Activity Drilldown and the SQL Server | Home Page. For more information, see Configure | SQL Server Response Time.

SQL Analysis Filters

Enable SQL Analysis. Configure the filters used to gather SQL Analysis data. For more information, see Configure | SQL Analysis.

Monitored Files

Track the growth of files (usually log files) on monitored Windows Servers. For more information, see Configure | Monitored Files.

Note: The visibility of some of these options is dependent on connection type.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating