Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Federation Guide

Spotlight Clients and the primary server

Connect a Spotlight Client to a federation by connecting the Spotlight Client to any Spotlight Diagnostic Server in the federation. This is the primary server for the Spotlight Client.

Connect a Spotlight Client to a federation

  1. Click Configure | Diagnostic Server.

  2. Click Select a Diagnostic Server
  3. In the Host field type or select the machine name where the Spotlight Diagnostic Server is installed.

Federation and playback data

In a federation of Spotlight Diagnostic Servers, each Spotlight Diagnostic Server connects to its own Playback Database.

Federation and the Spotlight Cloud

In a federation of Spotlight Diagnostic Server each Spotlight Diagnostic Server is independently configured for Spotlight Cloud.

 

 

 

Remove (break apart) a federation

Steps to remove a Spotlight Diagnostic Server from the federation

  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 to remove.
  4. Click Remove.
  5. Confirm your request to remove the Spotlight Diagnostic Server from the federation.

Table 2: The federation now the Spotlight Diagnostic Server has been removed

Spotlight Description
Monitored connections

Spotlight Clients connected to the federation can no longer monitor connections from the removed Spotlight Diagnostic Server.

Spotlight Clients with the removed Spotlight Diagnostic Server as their primary server are no longer connected to the federation.

Custom views

The Custom Views in the federation no longer show monitored connections from the removed Spotlight Diagnostic Server.

Alarm Actions

All Alarm Actions with condition "Where the Diagnostic Server is…" the removed Spotlight Diagnostic Server are removed from the federation.

Planned Outages Planned Outages for the federation no longer show monitored connections from the removed Spotlight Diagnostic Server.
Configuration templates

All Configuration templates remain available to the federation.

Spotlight license

The Spotlight license for the federation does not change. Note that if the Configuration server is removed from the federation the Spotlight license does change to the license of the federation's new Configuration server.

Table 3: The Spotlight Diagnostic Server that was removed from the federation

Spotlight Description
Monitored connections

Spotlight Clients with the removed Spotlight Diagnostic Server as their primary server are no longer connected to the federation. They monitor connections directly from the Spotlight Diagnostic Server.

Custom views

Any Spotlight Client connecting to the Spotlight Diagnostic Server will have access to all Custom Views from the federation. The Custom Views show only connections monitored directly from the Spotlight Diagnostic Server.

Alarm Actions

Alarm Actions with condition "Where the Diagnostic Server is…" the removed Spotlight Diagnostic Server are available to the Spotlight Diagnostic Server when it is removed from the federation. Alarm Actions from the federation that do not have the condition "Where the Diagnostic Server is…" are also available to the Spotlight Diagnostic Server when it is removed from the federation.

Planned Outages Any Spotlight Client connecting to the Spotlight Diagnostic Server will have access to all Planned Outages on connections monitored by that Spotlight Diagnostic Server.
Configuration templates

The configuration templates from the federation remain accessible to the Spotlight Diagnostic Server after it has been removed from the federation.

Spotlight license

The Spotlight Diagnostic Server takes on the Spotlight license that was given to it when it joined the federation; that is the Spotlight license applied to the Configuration server at the time the Spotlight Diagnostic Server joined the federation.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating