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 | Manage the connections monitored by Spotlight. |
 |
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 | 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 | Spotlight collects data according to these set schedules. Select any template or monitored connection in the federation to configure. |
 |
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 | 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 | 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 | 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 | 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.
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.
