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

Chat now with support

Drilldown on memory usage for the Analysis Services server.

To see the Memory drilldown

To investigate...	Look at the...
Memory usage for the Analysis Services server	Memory drilldown	Cache chart The Cache chart shows performance counters from Analysis Services. For information on the counters shown in the Cache chart, search Microsoft SQL Server Books Online for "Agg Cache Object". To switch between statistics, click the arrow next to the chart name. Proactive caching chart Shows statistics for proactive caching. Proactive caching is a feature in Analysis Services that prevents cubes from becoming out of date by automatically updating them according to configurable parameters. Memory chart Memory usage of the server process. Threads chart Shows statistics for the different thread pools. To see statistics for a different thread pool, click the arrow next to the chart name.

TIP: For more information about how to use Spotlight charts, see Spotlight charts