BI performance counter: Total NON EMPTY

Applies to

SSAS

Description

This performance counter relates to the measurement of Analysis Services MDX calculations. NON EMPTY keyword can be used in MDX expression to exclude empty cells from a result set.

This performance counter monitors the total number of times a NON EMPTY keyword was used. The NON EMPTY keyword can only be used at the axis level. There is a distinction between NON EMPTY keyword and NONEMPTY function, this counter monitors the former.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Consider optimizing your MDX calculations
  2. Understand the differences between NON EMPTY keyword and NONEMPTY function
  3. Use SQL Server Profiler to monitor query definitions
  4. Use DMVs to monitor query definitions

Additional research

NonEmpty (MDX)
Non Empty vs NonEmpty(): To The Death!
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