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 SwitchingSwitching (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.

...

• • SSAS Processing
    Displays charts for: Rows Written, Aggregation Rows, and Index Processing.
  • Query Activity (Active Queries & All Queries)
    • Active Queries, displays  displays a list containing general information about active queries in the BI environmentof all currently executing MDX/DAX queries. The list can be filtered by User and Session SPID.
    • All Queries, displays charts for Cell ActivityActivity (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, Vertipaq MemoryNon-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 TransactionsTransactions (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 ThreadsThreads (Idle vs. Busy), Processing Pool Job Queue Length, Flat Cache Activity (Cache Lookups vs. Cache Hits), and Calculation Cache ActivityCache Activity (Cache Lookups vs. Cache Hits).
  • SSAS Storage Engine Cache
    Displays the following charts: Data File ActivityActivity (Bytes Read vs. Logical Reads vs. Queries From File), Cache Copy Reads, Queries Answered from Cache, Filtered Queries Answered from Cache, Query Average Time per Query, Dimension Cache ActivityActivity (Cache Hits vs. Cache Lookups), and Measure Group Cache ActivityCache Activity (Cache Hits vs. Cache Lookups).

Session

This category displays a list with general information about of user sessions within the BI environment and a drop-down metric selector to choose from with the following optionscolumns:

• • Session ID
  • Status
  • Session SPID
  • Connection ID
  • User
  • Database
  • Start Time
  • Command Count
  • Last Command Start
  • Last Command End
  • Last Command
  • CPU Time (ms)
  • Reads (KB)
  • Writes (KB)
  • Used Memory

...

This category displays a list with general information about of all objects within the BI environment cube or tabular model with the following columns:

...

This category displays a list of all Users' activities within the BI environment. The list includes the following information:

• • User nameName (clicking on a Session will display all activity from the user)
  • Sessions
  • CPU Utilization (ms)
  • Memory Usage (KB)

...

SQL Business Intelligence Manager identifies issues within the SQL BI environment to help optimize BI service performance. Learn more > >

...

...