Applies to
SSAS
Description
Partition can be defined as the physical unit of storage that stores a subset of the Analysis Services database data. This performance counter relates to the measurement of Analysis Services processing of aggregations in MOLAP data files and it monitors the total amount of partitions processed. The total amount of partitions processed refers to both successfully and unsuccessfully processed partitions.
Resolved by
DBAs, Server administrators, BI developers
Suggested solutions
- When creating hierarchies, you should make as many of them natural as possible
- Reduce the number of attributes in the dimensions
- Manage partitions using the free tool, SSAS Partition Manager
- 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
Use cube partitions to improve Analysis Services performance
Performance Counters (SSAS)
Avoid Common SQL Server Analysis Services Problems
Partitions (Analysis Services – Multidimensional Data)