BI performance counter: Total cells calculated

Applies to

SSAS

Description

This performance counter relates to the measurement of Analysis Services MDX calculations. An Analysis Services query can either use cell-by-cell calculation or block calculation (or computation). This performance counter monitors the total number of cell properties calculated. A high value for this counter usually indicates a need for query optimization.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Modify the query until you stop seeing big increments in cell calculated for your query
  2. Use SQL Server Profiler to identify if bottleneck is with Analysis Services Formula Engine
  3. Use Performance Monitor to confirm that the query is using cell calculation instead of block calculation
  4. Consider optimizing your MDX calculations

Additional research

Identifying Cell by Cell Computation Mode in MDX queries
Examining MDX Query performance using Block Computation
Performance Counters (SSAS)

 

To track BI performance metrics – consider using ApexSQL BI Monitor, a web application that monitors system, SSAS, SSIS and SSRS performance in real time.

⇐ Back to index