Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Deployment Guide

Welcome to Spotlight on SQL Server The size and shape of your deployment Install / Upgrade Spotlight data collection and storage View data and configure Spotlight Monitored connections in the deployment Deployment over the Windows network Monitored SQL Servers Monitored Windows Servers and hosts of database connections

Deployment of federated Spotlight Diagnostic Server

Spotlight data collection and storage > Spotlight Dignostic Server > Deployment of federated Spotlight Diagnostic Server

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.

For more information, refer to the Spotlight on SQL Server Enterprise Federation Guide.

Playback Database

Recent historical information (collected from monitored connections) is stored in the Playback Database.

Deployment

The Playback Database is deployed on SQL Server. For specifications, see the Spotlight on SQL Server Enterprise Release Notes.

The Playback Database is created by the Spotlight installer. For more information, see Install.

There is one Playback Database per Spotlight Diagnostic Server.

Configuration

Use a Spotlight Client to configure the Playback Database.

Maintenance

Backup Spotlight data

The Playback Database is deployed on SQL Server. The backup procedure is the same as for any other SQL Server database.

Maintenance plan for Spotlight Statistics Repository and Playback Database

It is highly recommended that regular maintenance is performed to maintain efficient data retrieval.

Spotlight Statistics Repository

Spotlight data collection and storage > Spotlight Statistics Repository

Long term history for reporting and trending is stored in the Spotlight Statistics Repository.

Deployment

The Spotlight Statistics Repository is deployed on SQL Server. For specifications see the Spotlight on SQL Server Enterprise Release Notes.

The Spotlight Statistics Repository is not created during the installation of Spotlight on SQL Server. The Spotlight Statistics Repository is (optionally) enabled in the Spotlight Client for the Spotlight Diagnostic Server following installation of Spotlight.

Many Spotlight Diagnostic Server can connect to one Spotlight Statistics Repository.

Configuration

Use a Spotlight Client to enable, create and Configure the Spotlight Statistics Repository.

Maintenance

Backup Spotlight data

The Spotlight Statistics Repository is deployed on SQL Server. The backup procedure is the same as for any other SQL Server database.

Maintenance plan for Spotlight Statistics Repository and Playback Database

It is highly recommended that regular maintenance is performed to maintain efficient data retrieval.

Upgrade

Following upgrade of the Spotlight Diagnostic Server, the Spotlight Statistics Repository is automatically upgraded the next time it is accessed by the Spotlight Diagnostic Server. This may be some time following the upgrade of the Spotlight Diagnostic Server, depending on how often the Spotlight Statistics Repository is accessed.

If in your environment the Spotlight Statistics Repository is replicated as per a Microsoft Replication database the upgrade can fail if schema changes are required that can only be made when replication is turned off. To successfully upgrade the Spotlight Statistics Repository, the steps are to: turn replication off, upgrade the Spotlight Diagnostic Server, then re-enable replication.

Spotlight Cloud

Upload health performance data to the Spotlight Cloud.

To retrieve an analysis of this data, sign in with your Spotlight Cloud credentials to www.spotlightessentials.com

Configuration

The Spotlight Diagnostic Server must be configured to allow upload of data to the Spotlight Cloud.

  1. Ensure the Spotlight Diagnostic Server can access the Internet. For more information, see Spotlight services requiring Internet access.
  2. Create a Spotlight Cloud account if you do not already have one. Go to www.spotlightessentials.com. Note that the Spotlight Cloud was previously called Spotlight Essentials - you can sign in with a Spotlight Essentials account.
  3. Use a Spotlight Client to Configure uploading to Spotlight Cloud. Data is uploaded from the Spotlight Diagnostic Server to the Spotlight Cloud.

TIP: In a corporate enterprise your Spotlight Cloud account may receive a request to join an organization. In an organization, performance analysis data is uploaded to the organization and is available to all members of the organization. Members of the organization see a combined heat map and alarms list.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating