Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

Spotlight Collections for Analysis Services

Spotlight Collections for Analysis Services

The following collections are used for displays (alarms, home page components and drilldowns).


  • Background collection schedules (collected when no Spotlight client is displaying that collection) are configurable unless otherwise stated. Collections with Cfg=N are non configurable.
  • Some collections are used for multiple displays (home page components and drilldowns). Modifying a collection schedule may impact more than just one display.
  • To configure the collection schedule, see Configure | Scheduling.
  • Data collected by background collection schedules is stored in the Playback Database.
  • For collections specific to reporting, see Spotlight collections for Reporting and Trending

Table 28: Collections - About each alarm

Alarm Collection Name
Command - Long Running Command Alarm SSAS - Command List
Cubes - Days Since Last Processed Alarm SSAS - Cube List
Cubes - Unprocessed Alarm SSAS - Cube List

Table 29: Collections - Analysis Services | Home Page

Home Page Panel Home Page Component Collection Name
Connections Panel Connections SSAS - Connection
User Sessions SSAS - Connection
Avg Time Per Query SSAS - Storage Engine Query
Data Flow: Queries Answered/s SSAS - Storage Engine Query
Data Flow: Queries Requested/s SSAS - Connection
Data Flow: Queries From Cache Direct SSAS - Storage Engine Query
Data Flow: Queries from Cache Filtered SSAS - Storage Engine Query
Data Flow: Queries From File SSAS - Storage Engine Query
Memory Panel Memory Limit Low SSAS - Memory
Memory Limit High SSAS - Memory
Memory Usage SSAS - Memory
Current Latch Waits SSAS - Locks
Current Lock Waits SSAS - Locks
Query Pool Job Queue Length SSAS - Threads
Data Flow: Temp File Rows Written SSAS - Proc Aggregations
Data Flow: Rows Read SSAS - Processing
Data Flow: Rows Written SSAS - Processing
Storage Panel - SSAS - Database Summary

Table 30: Collections - SQL Server Analysis Services

Drilldown Page / Grid / Chart Collection Name
Analysis Services | Activity Drilldown Connections page SSAS - Connection List
Sessions page SSAS - Session List
Commands page SSAS - Command List
Analysis Services | Memory Drilldown Cache chart SSAS - Cache
Proactive Caching chart SSAS - Proactive Caching
Memory chart SSAS - Memory
Threads chart SSAS - Threads
Analysis Services | Storage Drilldown Databases page SSAS - Database List
Cubes page SSAS - Cube List
Analysis Services | Configuration Drilldown - SSAS - Server Properties
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating