Spotlight
®
Toggle navigation
Setup and Deploy
Install Spotlight Enterprise
Configure Diagnostic Server
Backend deployment
Federation of Diagnostic Servers
Interfaces
Spotlight Client
Cloud Connect
Spotlight Cloud Mobile
Spotlight Management Pack for SCOM
PagerDuty
Windows Powershell / Command line access
Connection Types
SQL Server
SQL Server Analysis Services
SQL Server Availability Group
SQL Server Replication
Azure SQL Managed Instance
SQL Azure
Unix/Linux
Windows server
VMware
Hyper-V
Spotlight Diagnostic Server
Spotlight Enterprise 14.1.2
Getting Started
Welcome
Release Notes
Release Notes
New features
Resolved issues
Known issues
System Requirements
Product Licensing
Upgrade and installation instructions
More resources
Globalization
Install, Upgrade, Uninstall
Install
Upgrade
Uninstall
Product License
Support
Build the Support Bundle
Legal
About Us
Copyright Information
Third Party Components
Privacy Policy
Using the Spotlight Client
Using the Spotlight Client
Permission to use Spotlight
Configure the Spotlight Client
Appearance of charts
Overview page click action
Severity colors for accessibility
Spotlight startup location
Adjust display performance and quality
Choose Help location
Configure support bundle emails
Enable debug logging
Configure user experience
Configure the Spotlight Client host
Internet Options
Microsoft App-V
Displays
Heat Map
Spotlight Today
Alarms by Time
Alarm log
Connections
Connections display
Custom views
New Connection View Properties
Connection View Properties
Select Connections
Tags
Planned Outages
Spotlight Overview pages
Spotlight grids
Spotlight grids
Toolbar
Header row
Grid content
Properties
Spotlight charts
Spotlight charts
Toolbar
Legend
Chart content
Compare - Select time range (Baselining)
Properties (Chart)
Properties (Chart filters)
Playback
Reports
Spotlight Reports
The Spotlight Report Viewer
Access Spotlight Reports from a Web Browser
List the Default Reports
Collections used by the Default Reports
Query the Spotlight Statistics Repository
Query the Spotlight Statistics Repository
The Schema
Collected data
Query tables to return results
Table Definitions
Spotlight API Stored Procedures
Additional stored procedures
Alarms
Diagnose
Acknowledge
Snooze
Ignore
Push Notifications
Relationship between alarms and schedule
Configure monitoring
Configure monitoring
Configure Connections
Configure Connections
Delete Connections
Connection Tags
Connection Monitoring
Connection Discovery Wizard
Configure Alarms
Configure Alarms
Configure an alarm
Severity thresholds
Alarms - Message Variables
Ignore Values
Custom Counters
Configure Alarm Actions
Configure Alarm Actions
Alarm Action dialog
Send push notification to
Send email to
Run a program
The connection is
Example alarm action rules
Configure Scheduling
Configure Scheduling
Configure a Schedule
Configure Planned Outage
Configure Planned outage
Planned Outage Details
Configure SQL Server Response Time
Configure Custom Counters
Configure Custom Counters
Add Custom Counters
Configure Error Log Entries
Configure Disks Display
Configure Monitored Files
Configure Monitored Files
Add File
Configure Defragmentation Check
Apply configuration to...
Apply configuration to...
Choose configurations
Select connections
Preview changes
Configuration Templates
Configuration templates
Save to template
Configure Diagnostic Server
Select a Diagnostic Server
Configure the database maintenance schedule
Configure PagerDuty
Manage access to Spotlight connections
Configure the Diagnostic Server's mail server
Configure the Diagnostic Server's mail server
SMTP mail options dialog
Configure the Playback Database
Configure the Playback Database
Create Playback Database dialog
Configure SNMP trap
Configure the Spotlight Statistics Repository
Configure the Spotlight Statistics Repository
Create Spotlight Statistics Repository dialog
Configure the use of Extended Events
Store SQL Text and Query Plans in Playback
Configure uploading to the Spotlight Cloud
Federate Diagnostic Servers
Beyond the Spotlight Client
Spotlight Mobile
Spotlight web site
Pager Duty
Spotlight Management Pack for SCOM
Spotlight Management Pack for SCOM
Requirements
Download, Unpack and Configure
Workflow for Spotlight alarms
SCOM Console views of Spotlight
Snooze and Acknowledge Spotlight alarms
Launch the Spotlight Client from the SCOM Console
Troubleshooting
Windows Powershell / Command line access
Windows Powershell / Command line access
Spotlight Connections
Alarms
Manage Connection Access
Schedule planned outages
Get Workload Analysis data
Backend deployment
Backend Deployment
Spotlight Diagnostic Server
Spotlight Diagnostic Server
Spotlight services requiring Internet access
Start and stop the Spotlight Diagnostic Server
Java KeyStore
Import an Email Certificate into Spotlight
Playback Database
Spotlight Statistics Repository
Spotlight Statistics Repository
Relocate the Spotlight Statistics Repository
Spotlight Cloud
Database Objects and Privileges
Maintenance plan
Migrate Spotlight to a new Diagnostic Server host
Backup Spotlight Data
Log of user actions
Deployment over the Windows Network
Network ports
Spotlight diagnostic user groups
TLS 1.2 only environments
WMI
Troubleshooting WMI
How to limit the number of ports used by WMI
Federation
Federation
Separate an existing deployment
Make (add to) a federation
Monitoring connections
Configure operations
Upgrade Spotlight
Remove (break apart) a federation
Spotlight grids
Spotlight uses grids to show tabular data in drilldowns and views of raised alarms.