Page History

SQL BI Manager monitors several type of metrics to provide accurate information about the status and health of the Analysis Services and the instances hosting these services. The metrics are classified in the following categories:

Server Performance

This category contains the following server-related performance metrics:

• • 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 Memory 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 Performance

This category contains the following SSAS related performance metrics:

• • 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 Memory, and Vertipaq Mapped 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 ActivityActivity (Cache Lookups vs. Cache Hits).
  • SSAS Storage Engine Cache
    Displays the following charts: Data File ActivityFile Activity (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
  • Data Read (KB)
  • Data Write (KB)
  • SPID
  • Username
  • Used Memory
  • Properties
  • Status
  • Start Time
  • ReadsCommand Count
  • Writes
  • Last Command Start Time
  • Last Command Elapsed TimeEnd
  • Last Command End Time
  • CPU Time (ms)
  • Reads (KB)
  • Writes (KB)
  • Used Memory

The items displayed in this list can also be filtered by Status, Session SPID, Connection ID, User, and Database.

Object Utilization

This category displays a list with general information about of all objects within the BI environment and a drop-down metric selector to choose from the following options:cube or tabular model with the following columns:

• • BISM
  • Type
  • Object ID
  • CPU Time (ms)
  • Object Hit
  • Object Miss
  • Aggregation Hit
  • Aggregation Miss
  • Reads (KB)
  • Writes (KB)
  • Rows Returned
  • BISMRows Scanned
  • Object Type

The items displayed in this list can also be filtered by BISM, Object Type, and Object ID.

SSAS Model Name

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

• • SSAS Model Name
  • Last Schema Update
  • Last Data Update
  • Write Enabled
  • SQL Enabled
  • Drill Through Enabled
  • Base Cube
  • Catalog Name
  • Cube Caption
  • Cube Type
  • Description
  • Cube Size (MB)

User activity

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 > >

...

...