July 13, 2017 at 2:44 am
Hi All,
We have been given a task to optimize 5-6 SSAS tabular cubes having sizes of 10 to 15 GB each. Couple of cubes are taking 6 to 7 hours to complete processing.
I saw in few tabular cubes few columns and even tables are kept hidden. I believe even if these columns/tables are hidden they are contributing into memory consumption. Am I right?
Please let me know other tips to improve performance/processing of these cubes.
PS: SQL Server 2012 is cube version
Thanks!
BigB
July 13, 2017 at 11:38 am
BigB - Thursday, July 13, 2017 2:44 AMHi All,We have been given a task to optimize 5-6 SSAS tabular cubes having sizes of 10 to 15 GB each. Couple of cubes are taking 6 to 7 hours to complete processing.
I saw in few tabular cubes few columns and even tables are kept hidden. I believe even if these columns/tables are hidden they are contributing into memory consumption. Am I right?
Please let me know other tips to improve performance/processing of these cubes.
PS: SQL Server 2012 is cube version
Thanks!
BigB
One thing I just noticed is you are on 2012. Have you applied any service packs, updates yet? There is a bug related to slow processing:
FIX: The time is longer and longer to perform process full on an SSAS 2012 or SSAS 2014 tabular model database
You may want to try to figure out if particular areas of the processing are slow - specific dimensions, measure groups, cubes. Running profiler during the processing can help with this.
You can find a lot of articles about general best practices, configurations. This article is pretty good as it addresses processing in particular:
SQL Server Best Practices Article
Sue
July 13, 2017 at 5:36 pm
Are you processing the entire cube each time ?
Do any of the tables have partitions ?
You can most likely change this to only process changed data but it will most likely require partitions.
We have a 50GB tabular cube (ssas 2016) and our processing takes less than an hour due to only processing partitions that have changed.
If you provide more details on your cubes i may be able to provide some pointers.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply