How to open the Memory drilldown
From the Spotlight Client
- Select the connection from the left Connections pane.
- Click Monitor | Memory from the ribbon.
About the Memory drilldown
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 usage of the server process.
Shows statistics for the different thread pools.