Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Federation Guide

Why federation

The standard Spotlight configuration has one Spotlight Diagnostic Server. All connections are monitored through the Spotlight Diagnostic Server.

More than one Spotlight Diagnostic Server may be required when:

  • The number of connections to monitor exceeds the design of one Spotlight Diagnostic Server. A single Spotlight Diagnostic Server is designed to monitor a maximum of 100 SQL Servers, Analysis Services or Replication instances and 100 Windows servers.
  • Your organization is suited to the deployment of geographic hubs, where each geographic region deploys its own Spotlight Diagnostic Server.

Multiple Spotlight Diagnostic Server are deployed separately or as a federation.

Separate Spotlight deployments Federation
A Spotlight Client monitors connections from one Spotlight Diagnostic Server at a time. The deployments do not share custom views, templates and alarm actions. A Spotlight Client monitors connections from all Spotlight Diagnostic Server in the federation. Spotlight Clients in the federation share the same custom views, templates, alarm actions and list of planned outages.

Make (add to) a federation

Start with two separate Spotlight deployments.

Note: A Spotlight Diagnostic Server can connect to one federation at a time. Remove a Spotlight Diagnostic Server from one federation before adding it to a different federation.

The Spotlight Diagnostic Servers in the federation cannot be monitoring the same connections. Where duplicate connections exist, federation cannot proceed. Spotlight will prompt you to delete duplicate connections.

Each Spotlight Diagnostic Server in the federation must be running Spotlight version 11.6 or later.

Each Spotlight Diagnostic Server in the federation authenticates with one selected Spotlight Diagnostic Server in the federation (the Configuration server). Each Spotlight Diagnostic Server authenticates with the Configuration server using Windows authentication over TCP port 40303. The Windows account that each Spotlight Diagnostic Server is running under must be valid in the domain of the Configuration server. Spotlight Diagnostic Server running under the built in Windows accounts (local system or network service) cannot be federated.

All Spotlight Clients in the federation retrieve monitoring information directly from the Spotlight Diagnostic Server. TCP port 3843 must be open for incoming connections from all Spotlight Diagnostic Server in the federation.

We suggest that a VPN is implemented with a federated system for increased security.

Steps to make (add to) a federation

  1. Open a Spotlight Client.

    If the federation already exists, open any Spotlight Client connected to the federation. When federating two separate Spotlight Diagnostic Server, open a Spotlight Client connected to either Spotlight Diagnostic Server.

  2. From the Spotlight Client, click Configure | Diagnostic Server | Federate Diagnostic Servers.
  3. Click Add. Select the host of the Spotlight Diagnostic Server. The Spotlight Diagnostic Server should be installed and operational and accessible to the Spotlight Client.

Table 1: On adding a Spotlight Diagnostic Server to the federation

Spotlight Description
Monitored connections

The Spotlight Clients connected to the Spotlight Diagnostic Server that has been added to the federation now connect to the federation of Spotlight Diagnostic Server. Spotlight Clients in the federation monitor connections from all Spotlight Diagnostic Server in the federation.

Data to / from monitored connections is communicated directly from Spotlight Diagnostic Server to Spotlight Client. It is required that all Spotlight Clients have open communications with all Spotlight Diagnostic Server in the federation.

Custom views

Spotlight Clients in the federation have access to all custom views in the federation. The custom views from the newly joined Spotlight Diagnostic Server will be accessible to all Spotlight Clients in the federation. Any two custom views with the same name will be merged into the one view.

Alarm Actions

Spotlight Clients in the federation have access to all Alarm Action rules in the federation. The condition "The Diagnostic Server is…" is added to every pre-existing Alarm Action rule from the newly added Spotlight Diagnostic Server. Do nothing for Alarm Action rules specific to that Spotlight Diagnostic Server. For Alarm Action rules applicable to the federation, remove the condition "The Diagnostic Server is…" and delete duplicate rules.

Planned Outages Spotlight Clients in the federation have access to all scheduled planned outages for all Spotlight connections monitored in the federation.
Configuration templates

Spotlight Clients in the federation have access to all configuration templates in the federation. The configuration templates from the 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.

Spotlight license

The Spotlight license applied to the Configuration server is applied to the federation. For more information, see Configuration server.

Monitoring connections

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.

Note: Spotlight Enterprise Views from all Spotlight Diagnostic Server in the federation will also be seen by all Spotlight Clients in the federation. If there are two Enterprise Views with the same name, the Enterprise View from the Configuration server will override the local Enterprise View. Note that Spotlight is deprecating Enterprise Views. We recommend taking advantage of the new Custom Views to monitor your SQL Server instances in groups.

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. For more information, see Add connections to the federation.

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 Analysis

Enable SQL Analysis. Configure the filters used to gather SQL Analysis data. Select any template or monitored connection in the federation to configure.

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.

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating