Applies to
SSAS
Description
This performance counter relates to the measurement of Analysis Services processing of indexes for MOLAP data files and it measures the total number of rows from MOLAP files used to create indexes. The value of this counter is reset whenever the service is restarted.
Resolved by
DBAs, Network administrators
Suggested solutions
- Do a Process Data and Process Index separately instead of a Process Full, as it reduces the stress on the server
- When creating hierarchies, you should make as many of them natural as possible
- Reduce the number of attributes in the dimensions
- You must ensure that the processing query that populates the temporary partition does not duplicate any data already present in an existing partition
Additional research
SSAS INDEX
Performance Counters (SSAS)
Tuning Analysis Services (SSAS) for better Parallel Aggregation/Index Processing
Improving cube processing time