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
- Modify the query until you stop seeing big increments in cell calculated for your query
- Use SQL Server Profiler to identify if bottleneck is with Analysis Services Formula Engine
- Use Performance Monitor to confirm that the query is using cell calculation instead of block calculation
- 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)
See more
Check out SpotLight, a free, cloud based SQL Server monitoring tool to easily detect, monitor, and solve SQL Server performance problems on any device