BI performance counter: Current number of cached evaluation nodes

Applies to

SSAS

Description

This performance counter relates to the measurement of Analysis Services MDX calculations. It monitors the current number of total cached evaluation nodes built by MDX execution plans.

Evaluation nodes are logical query plans generated by the Analysis Services Formula Engine to process query requests. Evaluation nodes can be created but not always executed. The value of this counter changes as MDX queries are executed from SSMS or browsing of cube using the Cube Browser in SSMS or BIDS/SSDT.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Setup extended events trace to monitor queries
  2. Use SQL Server Profiler and then analyze the trace offline
  3. Add more physical memory to the computer
  4. Consider optimizing your MDX calculations

Additional research

BISM MD: Introduction to Evaluation Nodes
Performance Counters (SSAS)
General monitoring for SQL Server Analysis Services using Performance Monitor

⇐ Back to index