The cost of SSAS metadata management
- We know that too many partitions can hurt performance and this is documented in a SQLCat blog where it states “Partitions have some metadata and when the number exceeds several thousand, the cost of managing this metadata becomes apparent”.

- Reduce the number of partitions in the database through merging partitions or splitting into multiple databases.
- You could move to SQL 2008 which does perform slightly better and reduces check time by about 25%. Still not good enough really……. (and yes that means you have a problem in 2005 & 2008)
- Wait until Microsoft address the issue. Well its not currently going to be addressed for 2005 or 2008 but we might see it in 2008 R2.
Categories: Analysis Services, Performance, Trouble Shooting
Comments (0)
Trackbacks (1)
Leave a comment
Trackback
-
October 9, 2012 at 15:20SSAS 2008 R2– Little Gems « Andrew Calvett's SQL Server Blog
Categories
- Analysis Services (27)
- Configuration (5)
- Locking (2)
- Memory (1)
- Performance (5)
- Processing (3)
- Profiler (2)
- Synchronisation (4)
- Tips (16)
- Trouble Shooting (8)
- Utilities (5)
- SQL Server (28)
- Backup (3)
- Configuration (7)
- Deadlock (2)
- DMV (2)
- Errors (3)
- Internals (4)
- Numa (1)
- Performance (11)
- Resource Governor (1)
- SQL Agent (3)
- SSMS (1)
- Uncategorized (1)
- Windows Server (5)
- Automation (1)
- Configuration (2)
- Tips (2)