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
Amazon RDS for SQL Server
Welcome
Welcome
Connect
Connection Details
Grant Account Permissions
Alarms (A-K)
Alarms
CPU Time Percentage Used
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 - 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
Locks - Blocked Processes
Locks - Deadlocks
Memory - Page Life Expectancy
Missing SQL Performance Counters
Monitored Server - Azure SQL Managed Instance Alarm Action Failure
Monitored Server - Azure SQL Managed Instance Alarm Evaluation Failure
Monitored Server - Azure SQL Managed Instance Collection Execution Failure
Monitored Server - Azure SQL Managed Instance Connection Failure
Monitored Server - Azure SQL Managed Instance Host Not Defined
Monitored Server - Azure SQL Managed Instance Planned Outage
Monitored Server - Azure SQL Managed Instance Secondary Connection Failure
Alarms (N-Z)
Network - Azure SQL Managed Instance Packets Error Rate
Performance Investigator
Poor Performance Health
SQL - Long Running SQL
SQL - Running out of Threads
SQL Agent - Jobs Failed
SQL Agent - Long Running Jobs (Percent)
SQL Agent - Long Running Jobs (Time)
SQL Custom Counters
SQL Virtual Log Files Count
Tempdb Auto Growth
Tempdb Contention
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
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
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
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
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
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
User Sessions
This shows the number of user (non-system) sessions, excluding SQL Server (Amazon RDS) Agent sessions.