Page History
...
- Disk
Includes the following charts: Disk transactions, Average Seconds per Transaction, Current Disk Queue Length, and Percent Idle Time. - Network
Includes Data Transfer (bytes/sec) and Network Output Queue Length charts. - Cache
Includes Cache Copy Read Hits Percent, Cache Copy Reads per Second, and Cache Faults charts. - CPU
Displays CPU Thread Switching (threads waiting vs. thread switches), Percent Process Time (Percent Privileged Time vs. Percent User Time), Percent Processor Time (Processor Time vs. SSAS Processor Time), and Interrupts per Second charts. - Processing
Displays a Process Working Set (Memory Working Set Vs. SSAS Working Set) chart - Memory
Includes the following charts: Memory Overall Usage, Available Memory, and Page Transactions.
- Disk
...
- 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 cells vs. Recomputed CellsRecomputes), 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-shrinkableLow Limit, High Limit, Shrinkable, Non-Shrinkable), Vertipaq Memory (Vertipaq Paged vs. Vertipaq Non -pagedPaged), 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 Cache Lookups vs. cache hitsCache Hits), and Calculation Cache Activity (cache lookups Cache Lookups vs. cache hitsCache Hits). - SSAS Storage Engine Cache
Displays the following charts: Data File Activity (Bytes Read vs. Logical Reads vs. Queries from fileFrom File), Cache Copy Reads Reads, Queries Answered from Cache, Filtered Queries Answered from Cache, Average Time per Query, Dimension Cache Activity (cache hits Cache Hits vs. cache missesCache Lookups), and Measure Group Cache Activity (cache hits Cache Hits vs. cache missesCache Lookups).
- SSAS Processing
Session
This category displays a list of user sessions within the BI environment with the following columns:
...
This category displays a list of all Users' activities within the BI environment. The list includes the following information:
- User name Name (clicking on a Session will display all activity for from the user)
- Sessions
- CPU Utilization (ms)
- Memory Usage (KB)
...
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. |
SQL Business Intelligence Manager identifies issues within the SQL BI environment to help optimize BI service performance. Learn more > >
(Overall, low limit, high limit, shrinkable, non-shrinkable)
...
The information displayed in the lists can also be exported to a PDF, XLS, or XML file. |