i need to optimize the duration of processing Cube,Fact table Record Count 100,00,00,00 Recoreds Current Duration Almost 18 hours
If any one Know how to Optimize Performance Please advice me
The main boost in performance you will get once you partition you cube.
Create partitions in your measure group and start processing them in parallel.
Please note the partitions are feature of Enterprise edition of SQL Server Analysis Services.
Take a look at the project REAL. http://www.microsoft.com/technet/prodtechnol/sql/2005/realastd.mspx for an example of how to partition your data and achieve processing performance.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment