Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

Chat now with support

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

Note:

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 14: 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

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

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
Analysis Services \| Storage Drilldown	Cubes page	SSAS - Cube List
Analysis Services \| Configuration Drilldown	-	SSAS - Server Properties