Tab Cube Performance Tuning

• quinn.jay

  SSCertifiable

  Points: 5505

  More actions

  September 16, 2017 at 10:19 am

  #149497

  I have a 2016 ver tab cube in a 2016 ver instance, being loaded by a 2016 ver SSIS package. It seems to load very slowly. It's reading a single fact view with a number of CASE statements, and 6 very small dim tables. What can I do to boost performance?

• Brian Carlson

  SSCarpal Tunnel

  Points: 4170

  More actions

  September 18, 2017 at 11:32 am

  #1959848

  Not sure if this is the cube processing or the source. Check the SSIS logs to see what the slow step or steps are.