This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Slow Aggs in new 11.1.2.4 environment

January 11 2017 at 3:54 PM
No score for this post
JS 
from IP address 108.171.130.163

This is kind of a vague question I know, but here goes.

We are in the middle of an upgrade from 11.1.2.3.500 to 11.1.2.4 (w/ .013) patch. We have a few large cubes, one at almost 100 GB and one around 50GB. Both of these are actually planning applications. We have noticed that our aggregations are significantly slower in the new .4 environment than they were in .3 One cube has a daily calc takes roughly 15 minutes in .3 but is taking almost 45 in .4. The other cube has a very long nightly process that takes roughly 8 hours in .3 but is taking about 24 hours in .4.

All things being equal, outline, db settings, config file settings, etc…I can’t understand why this is so much different. The new hardware is “supposed” to be better.

Has anyone run across this issue? Any ideas on what else I can check other than adjusting my cache settings for the billionth time?

Thanks.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. Re: Slow Aggs in new 11.1.2.4 environment - Pete on Jan 11, 2017, 9:00 PM
    1. Re: Slow Aggs in new 11.1.2.4 environment - JS on Jan 11, 2017, 9:30 PM
      1. Re: Slow Aggs in new 11.1.2.4 environment - er77 on Jan 12, 2017, 6:21 AM
      2. Re: Slow Aggs in new 11.1.2.4 environment - Javier on Jan 12, 2017, 9:06 AM
        1. Re: Slow Aggs in new 11.1.2.4 environment - JS on Jan 12, 2017, 11:25 AM
          1. Re: Slow Aggs in new 11.1.2.4 environment - Javier on Jan 12, 2017, 12:09 PM
     
  2. Re: Slow Aggs in new 11.1.2.4 environment - Gary Crisci on Jan 12, 2017, 12:58 PM
  3.  

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.