Sample Header Ad - 728x90

SSAS Tabular Cube partitioning - number of partitions

1 vote
1 answer
1436 views
We ha a Fact table with 500 milions of rows (data from 10 years - 60GB). I've partitioned this table on database level and SSAS Tabular Cube level as well - one month per partition to improve the overall browsing performance and SSAS Cube processing time. But last time I've heard that configuring more than 2 partitions for SSAS Tabular cube is not good. There should be max 2 partitions per tabular cube. Have you heard about something like that ? Is that true ?
Asked by Tomasz Wieczorkowski (362 rep)
May 19, 2017, 09:09 AM
Last activity: Jun 1, 2017, 07:34 PM