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

Install

Install / Upgrade > Install

Run the Spotlight on SQL Server installer. During installation you will be prompted to supply details for the Spotlight Client, Spotlight Diagnostic Server and Playback Database.

 

Table 2: Types of installation

Typical

Select to install the Spotlight Diagnostic Server on a computer networked to the current computer. Select to install the Spotlight Client on the current computer to connect to a pre-existing Spotlight Diagnostic Server.

Compact

Select to install the Spotlight Client and Spotlight Diagnostic Server on the current computer.

 

Table 3: About the Spotlight Client installation

Component Description

Install location

Default installation folder (32 bit system)

C:\Program Files\Quest Software\Spotlight on SQL Server

Default installation folder (64 bit system)

C:\Program Files (x86)\Quest Software\Spotlight on SQL Server

Note: Do not install the Spotlight Client in the same location as an existing (but different entity of) Spotlight.

If you install a different Spotlight after you have installed Spotlight on SQL Server, do not install the new Spotlight in the Spotlight on SQL Server directory.

 

Table 4: About the Spotlight Diagnostic Server installation

Component Description

Install location

Default installation folder for the Diagnostic Server (32bit and 64bit systems):

C:\Program Files\Quest Software\Diagnostic Server

During a Typical install the diagnostic server can be installed remotely. Consider installing the Spotlight Diagnostic Server on a computer that is always switched on. Some services require Internet access; see Spotlight services requiring Internet access.

Diagnostic Server Account

The Spotlight Diagnostic Server will run under this Windows account. Enter a domain user account or select the local system account. These credentials can later be used to authenticate Spotlight connections to monitor SQL Server instances and Windows Server.

Diagnostic Server Users

Spotlight uses the Spotlight diagnostic user groups to authenticate the Spotlight Client to the Spotlight Diagnostic Server, to authenticate a user's right to configure Spotlight and execute actions on monitored systems. The Windows user installing Spotlight (on the Spotlight Client) is automatically added to all Spotlight diagnostic user groups. For more information, see Spotlight diagnostic user groups.

Add more users to the Spotlight diagnostic user groups if required. Members of these groups can be Windows users or Windows domain groups. Aliases are not supported.

Auto-update Diagnostic Server

Selected The Spotlight Diagnostic Server will receive minor updates (scripts and configuration) automatically. Ensure the Spotlight Diagnostic Server can access the Internet. For more information, see Spotlight services requiring Internet access.
Not Selected All updates to the Spotlight Diagnostic Server will require a new version and installation of Spotlight on SQL Server.

Table 5: About the Playback Database installation

Component Description

Instance

Select the SQL Server instance to install the Playback Database on. The Playback Database can be installed on the same Windows Server as the Spotlight Diagnostic Server or a different server dependent on the size of the deployment. For more information, see The size and shape of your deployment.

Authentication

Select Windows or SQL Server authentication.

Database

Optionally rename the database. The default name is SpotlightPlaybackDatabase. If the database has not already been created, click Create to create the database.

Upgrade

Install / Upgrade > Upgrade

Use the Spotlight installer to upgrade from version 10.0 or later of Spotlight on SQL Server. To upgrade from an earlier version of Spotlight than 10.0, upgrade to at least version 10.0 before upgrading to 11.7. To upgrade from 10.5.0, first upgrade to 10.5.2 and then upgrade to 11.7.

Backup before upgrade

Backup all Spotlight configuration and saved collection data. For more information, see Backup Spotlight data.

Upgrade

On each Spotlight client, run the Spotlight on SQL Server executable.

Note:

  • Following upgrade of the Spotlight Diagnostic Server, the Playback Database and Spotlight Statistics Repository are automatically upgraded the next time they are accessed by the Spotlight Diagnostic Server. If in your environment the Playback Database / Spotlight Statistics Repository are 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 steps are to: turn replication off, upgrade the Spotlight Diagnostic Server, then re-enable replication.
  • If your enterprise has multiple Spotlight Clients then ensure all Spotlight Clients are included in the upgrade process. If the Spotlight Client and Spotlight Diagnostic Server are running different versions of Spotlight on SQL Server, the client will be unable to connect to the Spotlight Diagnostic Server.

Preservation of configuration information

The following information on the Spotlight Diagnostic Server is preserved when you upgrade:

  • Connection properties for all monitored servers (including changes to scheduling and alarms)
  • Enterprise views
  • Collection properties
  • Alarm Actions (These include running a program and sending an email.)
  • Planned Outages
  • Global options such as user-created Error Log rules
  • Configuration information for the Spotlight Statistics Repository (this applies only if you installed the Spotlight Statistics Repository from an earlier version of Spotlight on SQL Server) and the Playback Database.

Alarms requiring acknowledgment

The Spotlight factory settings for alarms requiring acknowledgment changes on upgrade from Spotlight 11.2. Only Connection Failure alarms are now factory set to require acknowledgment.

The alarms that were factory set to require acknowledgment in Spotlight 11.2 and earlier are as follows. They are included here so you can choose to manually enable them to require acknowledgment again post upgrade if required.

  • Availability Group - Failed Over
  • Clusters - Failed over
  • Diagnostic Server - Auto Update Success
  • Error Log - Error Count
  • LiteSpeed Backup Failed
  • LiteSpeed Backup Warning
  • Locks - Blocked Processes
  • Locks - Deadlocks
  • Mirroring Failedover
  • SQL Agent - Jobs Failed

Monitoring your Spotlight on SQL Server connections on a mobile device

If you used Spotlight 11.1.x or earlier to monitor your Spotlight on SQL Server connections on a mobile device and intend to continue monitoring your connections on a mobile device then the following additional upgrade instructions are required.

  1. Uninstall the Spotlight Web Publisher via Windows | Control Panel | Programs and Features. The Spotlight Web Publisher was required in the past to monitor SQL Server connections on a mobile device. It is now important that you uninstall it. By default the Spotlight Web Publisher was installed on the same computer as the Spotlight Diagnostic Server.
  2. From the Spotlight Client, click Configure | Spotlight Cloud. Select Upload data to Spotlight Cloud. Ensure your Spotlight Cloud (Spotlight Essentials) account details are correct.

Uninstall

Install / Upgrade > Uninstall

Multiple Spotlight clients and servers may be involved. Uninstall the Spotlight Diagnostic Server before you uninstall all Spotlight clients.

1. Optionally, backup before uninstall

Backup all Spotlight configuration and saved collection data. For more information, see Backup Spotlight data.

2. Uninstall the Spotlight Diagnostic Server

For the Windows server on which the Spotlight Diagnostic Server is installed:

  1. Open Windows Control Panel.
  2. Select Programs and Features
  3. Select Spotlight Diagnostic Server and click Remove.

Note: A running Spotlight Diagnostic Server is automatically shut down before being uninstalled.

3. Uninstall Spotlight Clients

Repeat for each Windows server on which a client is installed:

  1. Open Windows Control Panel.
  2. Select Programs and Features
  3. Select Spotlight on SQL Server Enterprise and click Remove.

The Playback Database and Spotlight Statistics Repository

The Playback Database and Spotlight Statistics Repository are not removed when Spotlight is uninstalled. You may delete them independently. You may use the Playback Database again with another Spotlight installation.

Spotlight data collection and storage

Data collection and storage

Table 6: Components of Spotlight that collect and store data

Component Description

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. The Spotlight Diagnostic Server is a Windows service. It runs under Windows credentials.

Playback Database

Recent history is stored in the Playback Database. The Playback Database is deployed on SQL Server. There is one Playback Database per Spotlight Diagnostic Server.

Spotlight Statistics Repository

Long term history for reporting and trending is stored in the Spotlight Statistics Repository. The Spotlight Statistics Repository is deployed on SQL Server. Deployment of the Spotlight Statistics Repository is optional per Spotlight Diagnostic Server.

Spotlight Cloud

Upload health performance data to the Spotlight Cloud. Deployment is optional per Spotlight Diagnostic Server.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating