Monitoring connections in a federation.
Edit me

Custom views

Any monitored connection in the federation can be added to any custom view. All Spotlight Clients have access to all custom views in the federation.

When a Spotlight Diagnostic Server joins a federation then the custom views from that Spotlight Diagnostic Server will be seen by all Spotlight Clients in the federation. Any two custom views with the same name will be merged into one view.

Configure monitoring

Configure monitoring of Spotlight connections from any Spotlight Client in the federation.

Icon Ribbon Select Description
Connections Connections Manage the connections monitored by Spotlight.
Alarms Alarms Set the thresholds and severities that determine when an alarm is raised. Select any template or monitored connection in the federation to configure.
Alarm Actions Alarm Actions Set actions for Spotlight to take when an alarm is raised. Alarm Action Rules may be specific to one Spotlight Diagnostic Server or applied to all Spotlight Diagnostic Server in the federation.
Scheduling Scheduling Spotlight collects data according to these set schedules. Select any template or monitored connection in the federation to configure.
Planned Outage Planned Outage Enter the scheduled maintenance times for the connections Spotlight monitors so Spotlight does not raise alarms and attempt to collect data during the outage period. Planned outages are listed for all monitored connections in the federation.
SQL Server Response Time SQL Server Response Time Set the SQL statement that is used to measure SQL Server response time. Select any template or monitored connection in the federation to configure.
Custom Counters Custom Counters Create and configure Custom Counters for monitoring connections to SQL Servers and Windows servers. Select any template or monitored connection in the federation to configure.
Error Log Entries Error Log Entries Request Spotlight raise an alarm when a specified entry is logged in the SQL Server error log. Select any template or monitored connection in the federation to configure.
Monitored Files Monitored Files Track the growth of specified files (usually log files) on monitored Windows Servers. Select any template or monitored Windows connection in the federation to configure.

Configuration templates

Spotlight Clients in the federation have access to all configuration templates in the federation.

The configuration templates from newly joined Spotlight Diagnostic Server will be accessible to all Spotlight Clients in the federation. Any two templates with the same name will both be renamed to remain separate.

Add connections to the federation

You will be prompted to select the Spotlight Diagnostic Server when you add a connection to a federated system. The new connection will be monitored through the selected Spotlight Diagnostic Server.

SQL Server connections

A SQL Server instance should be monitored on the same Spotlight Diagnostic Server as its SQL Server host.

SQL Server connections

Virtual environments

Where Windows hosts are in a virtual environment the Windows host should be monitored by the same Spotlight Diagnostic Server as the associated Hyper-V / VMware server.

Virtual environments