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

View data and configure Spotlight

View data and configure Spotlight

Table 12: View data and configure Spotlight

Component Description

Spotlight Client

The Spotlight Client is required to configure Spotlight and access Reporting and Trending data. The Spotlight Client is a comprehensive viewer to Spotlight data. The Spotlight Client is installed on a Windows server and connects to Spotlight Diagnostic Server on the Windows network.

Spotlight web site

Log in to the Spotlight web site with your Spotlight Cloud (Spotlight Essentials) credentials. Monitor your Spotlight connections, acknowledge and snooze alarms. View health performance analytics. Data is uploaded from Spotlight Diagnostic Server to the Spotlight Cloud over a secure Internet connection.

Spotlight Mobile

Monitor your Spotlight connections on your mobile device. Acknowledge and snooze Spotlight alarms on your mobile device. Data is uploaded from the Spotlight Diagnostic Server to Spotlight Cloud to Spotlight Mobile. A Spotlight Cloud (Spotlight Essentials) account is required to view data on a mobile device.

Spotlight Clients

The Spotlight Client is a comprehensive viewer to Spotlight data. The Spotlight Client is required to configure Spotlight and access Reporting and Trending data.

Installation

The Spotlight Client is installed on a Windows server. For specifications see the Spotlight on SQL Server Enterprise Release Notes.

The Spotlight Client is installed by the Spotlight installer. For more information, see Install. The Spotlight Client can be installed on the same Windows server as the Spotlight Diagnostic Server but does not have to be.

Deployment

The Spotlight Client connects to a single Spotlight Diagnostic Server or a federation of Spotlight Diagnostic Server.

Spotlight Diagnostic Server

Address the Spotlight Client to a Spotlight Diagnostic Server.

In a federation of Spotlight Diagnostic Server, select any Spotlight Diagnostic Server in the federation.

Spotlight Cloud

Use the Spotlight Client to Configure uploading to Spotlight Cloud.

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

Playback Database

Use the Spotlight Client to configure the Playback Database.

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

Spotlight Statistics Repository

Use the Spotlight Client to enable and configure the Spotlight Statistics Repository and generate reports.

In a federation of Spotlight Diagnostic Server each Spotlight Statistics Repository is independently configured in relation to the Spotlight Diagnostic Server.

Monitored connections in the deployment

Use the Spotlight Client to manage the connections monitored by Spotlight.

Troubleshooting

All data to / from the Spotlight Client passes through the Spotlight Diagnostic Server. Verify the Spotlight Client can connect to the Spotlight Diagnostic Server.

Permissions for the Spotlight Client

The Windows credentials used to run the Spotlight Client grant required permissions for the Spotlight Client to access the Spotlight Diagnostic Server, to configure the Spotlight Diagnostic Server, to acknowledge and snooze alarms, and execute actions on monitored systems like kill and pause.

If the Spotlight Client is in a different Windows domain to the domain that the Spotlight Diagnostic Server is in, the domain that the Spotlight Diagnostic Server is in must trust the domain that the Spotlight Client users are in.

Network ports

Spotlight's ability to function, to collect and display data, may depend on account permissions granted over the network and specific open network ports.

Verify Internet Options on the Spotlight Client

The Spotlight Client connects to the Spotlight Diagnostic Server via Internet port 40403. If you have customized Internet Options on the Spotlight Client, verify that your customized configurations do not conflict with Spotlight. See the online help for more information.

Spotlight Version

Ensure the Spotlight Client and Spotlight Diagnostic Server come from the same version of Spotlight. When upgrading Spotlight on SQL Server you must upgrade both the Spotlight client and Spotlight Diagnostic Server.

Permissions for the Spotlight Client

View data and configure Spotlight > Spotlight Clients > Permissions for the Spotlight Client

The Windows credentials used to run the Spotlight Client grant required permissions for the Spotlight Client to access the Spotlight Diagnostic Server, to configure the Spotlight Diagnostic Server, to acknowledge and snooze alarms, and execute actions on monitored systems like kill and pause.

The Windows credentials used to run the Spotlight Client must be a member of at least one of the following groups to access the Spotlight Diagnostic Server. The Spotlight Diagnostics User groups are created on install of the Spotlight Diagnostic Server. The Spotlight diagnostic user groups are as follows.

  • Administrator - Spotlight Diagnostic Administrators
  • User - Spotlight Diagnostic Users
  • Read-only - Spotlight Diagnostic Read-Only

The following tables document the permissions granted to each level of membership. For membership information and to increase your level of membership, see Spotlight diagnostic user groups.

Table 13: Permission to configure Spotlight

Configure Ribbon Tab Administrator User Read-only

Connections

Add/Delete connection profiles Yes Yes No
Add/Replace/Delete tags Yes Yes No
Enable/Disable monitoring connections Yes Yes No

Alarms

  Yes Yes No

Alarm Actions

Alarm Action Editor Yes Yes No
Run a program when a threshold is reached Yes No No

Scheduling

  Yes Yes No

Planned Outage

Add, edit and remove planned outagaes Yes No No

SQL Analysis

  Yes Yes No

SQL Server Response Time

  Yes No No

Custom Counters

  Yes Yes No

Error Log Entries

  Yes Yes No

Monitored Files

  Yes Yes No

Spotlight

Change Display Yes Yes Yes
Troubleshoot Spotlight Yes Yes Yes

Diagnostic Server

Select a Diagnostic Server Yes Yes Yes
Configure the database maintenance schedule Yes Yes No
Configure PagerDuty Yes Yes No
Configure the auto-update facility Yes Yes No
Configure the Diagnostic Server's mail server Yes Yes No
Configure the Playback Database Yes Yes No
Configure the SNMP Trap Yes Yes No
Configure the Spotlight Statistics Repository Yes Yes No
Configure the use of Extended Events Yes Yes No
Federate Diagnostic Servers Yes Yes No

Spotlight Cloud

Configure uploading to Spotlight Cloud Yes Yes No

User Experience

  Yes Yes No
Configuration Templates Apply Configuration To… Yes Yes No
Save as Template Yes Yes No
Delete Template Yes Yes No
Rename Template Yes Yes No

Table 14: Permission to acknowledge, snooze and ignore alarms from the Spotlight Client

Monitor | Alarms | Action Administrator User Read-only

Acknowledge

  Yes Yes No

Snooze Alarm

  Yes Yes No

Ignore Alarm

  Yes Yes No

Table 15: Permission to execute tasks on a monitored SQL Server from the Spotlight Client

Monitor | SQL Server Drilldowns Administrator User Read-only

SQL Activity

Sessions | Kill Session Yes No No

Databases

Indexes | Update Statistics Yes No No

Support Services

SQL Agent Jobs |  Start Job Yes No No
Service Status | Start / Stop Service Yes No No

Cluster Services | Take Offline

Cluster Services | Bring Online

Cluster Services | Move Group

Yes No No

Configuration

Change parameter Yes No No

Error Log

Cycle Error log

Yes No No

Table 16: Permission to execute tasks on a monitored Windows Server from the Spotlight Client

Monitor | Windows Drilldowns Administrator User Read-only

Processes

Processes | Terminate Yes No No
Services | Start Yes No No
Services | Stop Yes No No
Services | Pause Yes No No
Services | Resume Yes No No

Spotlight web site

View data and configure Spotlight > Spotlight web site

Monitor Spotlight connections from the Spotlight web site.

Monitoring features include a heat map, an alarms list, alarm details and the ability to snooze and acknowledge alarms.

Sign in with Spotlight Cloud credentials to www.spotlightessentials.com

Configuration

The Spotlight Diagnostic Server must be configured to allow you to monitor Spotlight connections from the Spotlight web site.

  1. Create a Spotlight Cloud (Spotlight Essentials) account if you do not already have one. Do this at www.spotlightessentials.com.
  2. Use a Spotlight Client to Configure uploading to Spotlight Cloud.

TIP: In a corporate enterprise your Spotlight Cloud (Spotlight Essentials) 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.

Deployment

Spotlight Diagnostic Server

Data is uploaded from the Spotlight Diagnostic Server to the Spotlight Cloud. Ensure the Spotlight Diagnostic Server has access to the Internet. For more information, see Spotlight services requiring Internet access.

Playback Database

Use a Spotlight Client to configure the Playback Database for the Spotlight Diagnostic Server. The Spotlight web site does not have the facility to configure the Playback Database.

Spotlight Statistics Repository

Use a Spotlight Client to access the Spotlight Statistics Repository. The Spotlight web site does not have access to the Spotlight Statistics Repository.

Monitored connections in the deployment

Use a Spotlight Client to manage the connections monitored by the Spotlight Diagnostic Server. The Spotlight web site does not have the facility to manage Spotlight connections.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating