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
Analysis Services
Welcome
Welcome
Connect
Connection details
Alarms
Alarms
Command - Long Running Command
Cubes - Days Since Last Processed
Cubes - Unprocessed
Monitored Server - Analysis Services Alarm Action Failure
Monitored Server - Analysis Services Alarm Evaluation Failure
Monitored Server - Analysis Services Collection Execution Failure
Monitored Server - Analysis Services Connection Failure
Monitored Server - Analysis Services Planned Outage
Monitored Server - Analysis Services Unsupported Version
Spotlight Overview page
Spotlight Overview page
Connections panel
Connections
User Sessions
Average Time Per Query
Flows
Queries Answered
Queries Requested
Queries from Cache Direct
Queries from Cache Filtered
Queries from File
Memory panel
Memory Limit Low
Memory Limit High
Memory Usage
Cleaner Balance/sec
Cleaner Memory Shrinkable
Filestore
Direct Hit Ratio
Current Latch Waits
Current Lock Waits
Query Pool Job Queue Length
Flows
Temp File Rows Written
Rows Read
Rows Written
Storage panel
Databases
Cubes
Server panel
Description
Edition
Version
Status
CPU panel
Virtualization Overhead
CPU usage
Activity drilldown
Activity drilldown
Connections
Sessions
Commands
Memory drilldown
Memory drilldown
Cache
Proactive Caching
Memory
Threads
Storage drilldown
Storage drilldown
Databases
Cubes
Configuration drilldown
Configuration drilldown
Configuration
Collections
Collections
Direct Hit Ratio
The ratio of cache direct hits to cache lookups.