Page History
...
- SSAS Processing
Displays charts for: Rows Written, Aggregation Rows, and Index Processing. - Query Activity (Active Queries & All Queries)
- Active Queries, displays a list of all currently executing MDX/DAX queries. The list can be filtered by User and Session SPID.
- All Queries, displays charts for Cell Activity (Cells Calculated vs. Recomputes), Calculation Covers, Sonar subcubes, and Non-Empty Algorithm Utilization (Un-optimized vs. Calculated Members).
- SSAS Memory
Includes charts for Memory Utilization (Overall Usage, Low Limit, High Limit, Shrinkable, Non-Shrinkable), Vertipaq Memory (Vertipaq Paged vs. Vertipaq Non Paged), and Vertipaq Mapped Memory (Vertipaq Memory Mapped vs. Memory Limit Vertipaq). - SSAS Cache
Displays charts for Cache Transactions (evictions/sec vs. inserts/sec) and Rate of Memory Added to Cache. - SSAS Formula Engine Cache
Includes the following charts: Query Pool Threads, Query Pool Job Queue Length, Processing Pool Threads (Idle vs. Busy), Processing Pool Job Queue Length, Flat Cache Activity (Cache Lookups vs. Cache Hits), and Calculation Cache Activity (Cache Lookups vs. Cache Hits). - SSAS Storage Engine Cache
Displays the following charts: Data File Activity (Bytes Read vs. Logical Reads vs. Queries From File), Cache Copy Reads, Queries Answered from Cache, Filtered Queries Answered from Cache, Average Time per Query, Dimension Cache Activity (Cache Hits vs. Cache Lookups), and Measure Group Cache Activity (Cache Hits vs. Cache Lookups).
- SSAS Processing
...
| Tip |
|---|
You can modify the time frame for the information and the scale (minute, hour, day, week, or month) used in the charts and export the views to an XLS or XML file. You can also print a specific chart or download it as a PNG, JPEG, PDF, or SVG file. The information displayed in the lists can also be exported to a PDF, XLS, or XML file. |