Spotlight
®
Toggle navigation
Setup and Deploy
Install Spotlight Enterprise
Configure Diagnostic Server
Backend deployment
Federation of Diagnostic Servers
Interfaces
Spotlight Client
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
Amazon RDS for SQL Server
SQL Azure
Unix/Linux
Windows server
VMware
Hyper-V
Spotlight Diagnostic Server
SQL Server
Welcome
Welcome
Connect
Connection Details
Connection Requirements
Grant account permissions
Alarms (A-K)
Alarms
Backup - Days Since Last Full Backup
Backup - Hours Since Last Differential Backup
Backup - Minutes Since Last Log Backup
Clusters - Failed Over
Clusters - File Share Witness Inaccessible
Clusters - Node Unavailable
Clusters - Non-Preferred Node
Compiles - Percentage Recompilations
Databases - Data File Group About to Grow
Databases - Data File Group Space Used
Databases - Dynamic Data File Group Growths Remaining
Databases - Dynamic Log File Growths Remaining
Databases - Log File Space Used
Databases - Log Flush Wait Time
Databases - SQL I/O Errors
Databases - Unavailable
Error Log - Critical Error (severity level lower than 20)
Error Log - Error Count
Error Log - Fatal Current Process Error (severity level 20)
Error Log - Fatal Database Integrity Suspect Error (severity level 23)
Error Log - Fatal Database (dbid) Processes Error (severity level 21)
Error Log - Fatal Hardware Error (severity level 24)
Error Log - Fatal Hardware Error (severity level 25)
Error Log - Fatal Table Integrity Suspect Error (severity level 22)
Error Log - High Severity Message
Error Log - Information Severity Message
Error Log - Low Severity Message
Error Log - Medium Severity Message
I/O Stall Time
Index Fragmentation
Index Fragmentation Status
Alarms (L-M)
Latch - Total Wait Time Rate
LiteSpeed Backup Failed
LiteSpeed Backup Warning
Locks - Blocked Processes
Locks - Deadlocks
Log Shipping - Primary Backup Job
Log Shipping - Secondary Job
Log Shipping - Secondary Latency
Memory - Page Life Expectancy
Mirroring - State
Mirroring - Unrestored Log
Mirroring - Unsent Log
Mirroring - Failedover
Missing SQL Performance Counters
Monitored Server - SQL Server Alarm Action Failure
Monitored Server - SQL Server Alarm Evaluation Failure
Monitored Server - SQL Server Collection Execution Failure
Monitored Server - SQL Server Connection Failure
Monitored Server - SQL Server Host Not Defined
Monitored Server - SQL Server Planned Outage
Monitored Server - SQL Server Secondary Connection Failure
Monitored Server - SQL Server Unsupported Version
Alarms (N-Z)
Network - SQL Server Packets Error Rate
Performance Investigator
Poor Performance Health
Services - DTC Service Status
Services - Full Text Search
Services - Integration Service Status
Services - Reporting Service Status
Services - SQL Agent Mail Status
SQL - Long Running SQL
SQL - Running out of Threads
SQL Agent - Alerts
SQL Agent - Jobs Failed
SQL Agent - Long Running Jobs (Percent)
SQL Agent - Long Running Jobs (Time)
SQL Agent - Status
SQL Custom Counters
SQL Virtual Log Files Count
Tempdb Auto Growth
Tempdb Contention
Tempdb File Location
Tempdb File Size
Tempdb Growth Settings
Tempdb Number of Files
Tempdb Version Store Generation Rate
Tempdb Version Store Size
User - Connection Count
User - Logins Per Second
User - Response Time
Spotlight Overview page
Spotlight Overview page
Sessions panel
Response Time
Sessions
Computers
Active
Active Sessions
Flows
Network Packets Sent
Network Packets Received
Batches
Processes Panel
Total
System
User
Blocked Processes
Virtualization Overhead
CPU Usage
Flows
Logical Reads
Compiles
Memory panel
Total Memory
Buffer Cache
Page Life Expectancy
Procedure Cache
Flows
Physical Reads
Physical Writes
Read Ahead
Checkpoint Page Writes
Lazy Writes
Log Flushes
Disk Storage panel
Databases
Tempdb
Data Files
Number of Data Files
Data Files Space Used
Percentage of Data Files Used
Log Files
Number of Log Files
Log Space Used
Percentage of Log Files Used
Fragmentation
Max I/O Stall Time
Max I/O Stall File
Performance Health panel
Performance Health
System panel
Version
Host
Custom
Status
Background Processes panel
Error Log
Services
Memory drilldown
Memory drilldown
Memory Areas
Server Memory
Hit Rates
Cache
Buffer Cache Page Life Expectancy
SQL Activity drilldown
SQL Activity drilldown
Sessions page
Sessions
SQL
Plan
Session Trace
Session Locks
Session CPU (Session Details)
Session I/O (Session Details)
Summary page
Access Methods
Cache Hit Rates
Call Rates
SQL Server I/O
CPU Utilization
Connected Sessions
Locks page
Locks
Lock Types
Latches
Blocking page
Blocking
Number of Blocked Processes
Deadlocks page
Deadlock List
I/O by File page
I/O by File grid
I/O by File chart
Custom Counters page
Custom Counters chart
Custom Counters grid
Query Execution Statistics page
Query Execution Statistics grid
SQL
Plan
Performance Health drilldown
Performance Health drilldown
Wait Statistics drilldown
Wait Statistics drilldown
Wait Time Trend
Waits Detail
Wait Events drilldown
Wait Events drilldown
SQL
Plan
High Availability drilldown
High Availability drilldown
Transaction Log Shipping page
Transaction Log Shipping Primaries
Transaction Log Shipping Secondaries
Transaction Log Shipping History
Transaction Log Shipping Secondary Database
Database Mirroring page
Database Mirroring grid
Database Mirroring details
Databases drilldown
Databases drilldown
Databases page
Databases grid
Summary page
Database Space
Database History
File Groups page
File Groups
File Groups Space
File Groups Growth
Data Files page
Data Files
Data Files Space
Data Files Growth
Transaction Logs page
Transaction Logs
Transaction Logs Space
Transaction Logs Growth
Log Files page
Log Files
Log Files Space
Log Files Growth
Tables page
Tables grid
Tables Space
Tables Growth
Indexes page
Indexes grid
Index Statistics Summary
Index Density
Index Distribution
Fragmentation
Disk Space page
Disk Space chart
LiteSpeed Backups page
LiteSpeed Backup History
Fragmented Indexes page
Fragmented Indexes grid
Support Services drilldown
Support Services drilldown
SQL Agent Jobs page
SQL Agent Jobs grid
Job History
SQL Agent Jobs Status
Service Status page
Service Status grid
Service Status History
SQL Agent Alerts page
SQL Agent Alerts grid
Alert Occurrences
Cluster Services page
Cluster Services grid
DTC page
DTC Details
Full Text Search page
Full Text Search Service
Configuration drilldown
Configuration drilldown
Configuration page
SQL Server Configuration grid
Error log drilldown
Error log drilldown
SQL Server Error Logs
SQL Agent Error Logs
Workload Analysis drilldown
Workload Analysis drilldown
SQL
Plan
Tempdb drilldown
Tempdb drilldown
Usage page
Tempdb Space Used
Version Store Size
Version Store Size Change
Top 25 Tempdb sessions
Contention page
Wait Time
Sessions involved in this contention
Collections
Collections
Collect additional diagnostic information
Troubleshooting
Troubleshooting
SQL Server 2017 and above hosted on Linux
SQL Server 2017 and above hosted on Linux
Server Memory chart
Shows the total memory that SQL Server is using, scaled against the target amount of memory it could use.