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

Spotlight Dignostic Server

Spotlight data collection and storage > Spotlight Diagnostic Server

The Spotlight Diagnostic Server is at the core of the Spotlight on SQL Server architecture. All Spotlight data passes through the Spotlight Diagnostic Server.

Installation

The Spotlight Diagnostic Server is a Windows service.

The Spotlight Diagnostic Server is installed by the Spotlight installer. For more information, see Install.

Most deployments of Spotlight have one Spotlight Diagnostic Server, however a deployment may consist of multiple Spotlight Diagnostic Server or a federation of Spotlight Diagnostic Server if the organization requires Spotlight to monitor more connections than a single Spotlight Diagnostic Server allows or the organization has setup geographic hubs.

Deployment

View data and configure Spotlight

Configure the Spotlight Diagnostic Server from Spotlight Clients.

Playback Database

Recent historical data is stored in the playback database. Each Spotlight Diagnostic Server requires its own Playback Database.

Spotlight Statistics Repository

Enabling of the Spotlight Statistics Repository is optional. Many Spotlight Diagnostic Server can connect to the same Spotlight Statistics Repository.

Monitored connections in the deployment

The Spotlight Diagnostic Server collects data from SQL Server, Windows and other supported connection types monitored by Spotlight.

A single Spotlight Diagnostic Server is designed to monitor a maximum of 100 SQL Servers, Analysis Services or Replication instances and 100 Windows servers. Exceeding this recommended limit on 32 bit environments may result in poor performance or product instability, due to the 1 Gb memory limit. On 64 bit environments theoretically more connections can be monitored as the 1 Gb limit no longer applies, however testing of this has been limited.

Deployment over the Windows network

A Spotlight on SQL Server deployment consists of many components that may be spread over a wide network. Spotlight's ability to function, to collect and display data, may depend on account permissions granted over the network and specific open network ports.

Spotlight services requiring Internet access

The Spotlight Diagnostic Server requires access to the Internet when enabling Auto Update or Spotlight Cloud services.

Account permissions

The Windows account that the Spotlight Diagnostic Server runs under could be a domain user account or the local system account. These credentials can be used to authenticate Spotlight connections to monitor SQL Server instances and Windows Server, and to connect the Spotlight Diagnostic Server to the Playback Database and Spotlight Statistics Repository.

Maintenance

Backup Spotlight data

Spotlight configuration data is stored in the conf folder on the Spotlight Diagnostic Server. You can perform backups of the Spotlight configuration data by backing up this folder regularly.

Start and stop the Spotlight Diagnostic Server

The Spotlight Diagnostic Server is a Windows service and can be started and stopped via the Windows Control Panel.

Diagnostic Server - Access to the Internet

Spotlight data collection and storage > Spotlight Dignostic Server > Diagnostic Server - Access to the Internet

The following Spotlight services require Internet access on the Spotlight Diagnostic Server. Use this page to ensure the Spotlight Diagnostic Server is appropriately configured.

Auto Update Enable Auto Update so the Spotlight Diagnostic Server will receive minor updates (scripts and configuration) automatically.
Spotlight Cloud Monitor Spotlight connections in a web browser or Spotlight Mobile. Upload performance data for health check analysis.

Windows Control Panel | Internet Options | Connections

On the computer hosting the Spotlight Diagnostic Server:

  1. Open the Control Panel | Internet Options.
  2. Select the Connections tab.
  3. Click LAN Settings.
  4. Ensure the settings on this screen are appropriate to the settings of your local environment.

Note: After the Spotlight Diagnostic Server is installed, restart the Spotlight Diagnostic Server after changes are made. For instructions see Start and stop the Spotlight Diagnostic Server.

 

Windows Control Panel | Internet Options | Advanced

On the computer hosting the Spotlight Diagnostic Server:

  1. Open the Control Panel | Internet Options.
  2. Select the Advanced tab.
  3. Ensure Use HTTP 1.1 and Use HTTP 1.1 through proxy connections are selected.

Note: After the Spotlight Diagnostic Server is installed, restart the Spotlight Diagnostic Server after changes are made. For instructions see Start and stop the Spotlight Diagnostic Server.

 

Internet URLs - Auto Update

An outgoing HTTPS connection to the following URL is used to retrieve updates.

https://spotlight.blob.core.windows.net

Enabling of Auto-update does not open a port that allows incoming connections.

 

Internet URLs - Spotlight Cloud

Spotlight Cloud requires incoming and outgoing HTTPS connections to the following URLs. To verify access to the Spotlight Cloud, open a web browser on the Spotlight Diagnostic Server host and look up these URLs.

URL Web browser lookup
https://www.spotlightessentials.com Successful display of the Spotlight web site confirms HTTPS port 443 is open.
https://api.spotlightessentials.com Successful display of the text “Welcome to Spotlight Web API!” confirms access for uploading.

Start and stop the Spotlight Diagnostic Server

Spotlight data collection and storage > Spotlight Dignostic Server > Start and stop the Spotlight Diagnostic Server

The Spotlight Diagnostic Server is a Windows service and can be started and stopped via the Windows Control Panel.

To start or stop the Spotlight Diagnostic Server

  1. On the Spotlight Diagnostic Server, open Windows Control Panel.
  2. Click Administrative Tools | Services.
  3. From the list of available services, double click on the Spotlight Diagnostic Server name: Spotlight Diagnostic Server.

  1. Click Start to start the Spotlight Diagnostic Server. Click Stop to stop the service.

Note: If you attempt to stop the Spotlight Diagnostic Server whilst a program or command line action that runs in response to an alarm is still executing, the Spotlight Diagnostic Server will wait until that program or command line action has ended before stopping.

Java KeyStore

A Java KeyStore (JKS) is a repository of security certificates.

After successfully changing the password, you can use the Java keytool (Agent\bin\jre\bin\keytool.exe) to change or sign the Spotlight Diagnostic Server certificate, which is stored in the "sosse" key alias.

To set the KeyStore password:

  1. Stop the Spotlight Diagnostic Server service. For more information, see Start and stop the Spotlight Diagnostic Server.
  2. From the Spotlight Diagnostic Server install folder, navigate to folder Agent\bin\
  3. Open a cmd shell as the Administrator.
  4. Execute command DSKeyToolCLI -storepasswd
  5. Enter a new password of at least 6 characters.
  6. Restart the Spotlight Diagnostic Server service. For more information, see Start and stop the Spotlight Diagnostic Server.

Verify that Alarm Actions and Planned Outages are working as expected.

Verify that a keystore password entry can be found in the Spotlight Diagnostic Server install folder conf\Service\WebServic.xml

For more information, see http://docs.oracle.com/javase/8/docs/technotes/tools/windows/keytool.html.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating