1.Click Configure | Connections.
2.Right-click the connection and select Properties | Monitoring.
The Monitoring page of the Connection Properties window contains configuration options for the target system and the Diagnostic Server.
Monitor this server
Select to monitor this connection using Spotlight Enterprise.
When not selected, no new data is collected by Spotlight Enterprise 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 | Spotlight Overview page. For more information, see Configure | SQL Server Response Time.