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.
DBAs, Server administrators, BI developers
- 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