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 Azure
Welcome
Welcome
Connections
Connection Details
Grant account permissions
Alarms (A-L)
Alarms
Compiles - Percentage Recompilations
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
I/O Stall Time
Index Fragmentation
Index Fragmentation Status
Latch - Total Wait Time Rate
Locks - Blocked Processes
Locks - Deadlocks
Alarms (M-Z)
Memory - Page Life Expectancy
Missing SQL Performance Counters
Monitored Server - SQL Azure Alarm Action Failure
Monitored Server - SQL Azure Alarm Evaluation Failure
Monitored Server - SQL Azure Collection Execution Failure
Monitored Server - SQL Azure Connection Failure
Monitored Server - SQL Azure Planned Outage
Network - SQL Azure Packets Error Rate
Poor Performance Health
SQL - Long Running SQL
SQL Custom Counters
SQL - Running out of Threads
SQL Virtual Log Files Count
Tempdb Auto Growth
Tempdb File Size
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
Connections
Computers
Active
Active Sessions
Flows
Packets Read
Packets Written
Batches
SQL 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
Data Storage panel
Data Storage
Tempdb
Data Files
Data Files Space Available
Data Files Space Used
Percentage of Data Files Space Used
Log Files
Log Files 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
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 Statement
Query Plan
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
Summary page
Database Space
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
Table Space
Table Growth
Indexes page
Indexes
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
Full Text Search page
Configuration drilldown
Configuration drilldown
Configuration page
SQL Server Configuration grid
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
Collections
Collections
Collect additional diagnostic information
Troubleshooting
Troubleshooting
Active Sessions Gauge
This gauge shows the percentage of non-system SQL Azure sessions that are active (running) or waiting on locks (blocked).