Drilldown on memory usage for the Analysis Services server.

How to open the Memory drilldown

From the Spotlight Client

  1. Select the connection from the left Connections pane.
  2. Click Monitor | Memory from the ribbon.
    Memory drilldown for Analysis Services

About the 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”.

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.