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.
DBAs, Server administrators, BI developers
- Consider optimizing your MDX calculations
- Understand the differences between NON EMPTY keyword and NONEMPTY function
- Use SQL Server Profiler to monitor query definitions
- Use DMVs to monitor query definitions
Non Empty vs NonEmpty(): To The Death!
Performance Counters (SSAS)