Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Federation Guide

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.

NOTE: A single Spotlight Diagnostic Server is designed to monitor a maximum of 100 SQL Servers, Analysis Services or Replication instances and 100 Windows servers.

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.

Configure operations

Any Spotlight Client in the federation can configure the operations of any Spotlight Diagnostic Server in the federation.

  1. Open the Spotlight Client.
  2. Click Configure | Diagnostic Server.
  3. Select the Spotlight Diagnostic Server operation to configure (Auto Update - Use of Extended Events).
  4. The dialog to configure the selected Spotlight Diagnostic Server operation opens. Select the Spotlight Diagnostic Server and set the new configuration.

Any Spotlight Client in the federation can configure the operations of the federation.

  1. Open the Spotlight Client.
  2. Click Configure | Diagnostic Server | Federate Diagnostic Servers.
  3. Add / Remove Spotlight Diagnostic Server from the federation and set the Configuration server.

Configuration server

One Spotlight Diagnostic Server in the federation is selected as the Configuration server.

Configurations shared between the Spotlight Diagnostic Server in the federation are applied to the Configuration server. Other Spotlight Diagnostic Server in the federation poll the Configuration server for updates.

The following configurations are applied directly from the Spotlight Client to the Configuration server. Other Spotlight Diagnostic Server in the federation poll for updates from the Configuration server.

  • Custom views
  • Enterprise views
  • Configured Alarm Actions
  • Planned Outages
  • Configuration templates

Note: If the Configuration server is down then any changes made by a Spotlight Client to any of the above configurations will not be saved.

If any other Spotlight Diagnostic Server in the federation is offline then when it is online again it will poll to receive updates from the Configuration server. The Configuration server keeps transactions (recording changes to the above configurations) for 5 days.

Steps to assign the Configuration server

  1. Open a Spotlight Client in the federation.
  2. From the Spotlight Client, click Configure | Diagnostic Server | Federate Diagnostic Servers.
  3. Select the Spotlight Diagnostic Server.
  4. Click Set as Configuration server.

Spotlight Diagnostic Server authenticate with the Configuration server using Windows authentication over TCP Port 40303. For each Spotlight Diagnostic Server in the federation, the Windows account that the Spotlight Diagnostic Server is running under must be valid in the domain of the Configuration server.

The Configuration server should have a reliable and fast Internet connection to each of the other Spotlight Diagnostic Server in the federation.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating