^^^SAN definition: http://en.wikipedia.org/wiki/Storage_area_networki ma no clear what do you mean by SAN.
^^^That's the way fragmentation works. Is this a budgeting application by any chance? I typically recommend nightly defragmentation for BSO Essbase cubes -- it really makes a difference.We tried restructuring, the time reduces in both server pos restructure, but increases back agaiin 2-3 days,
Hkag wrote:Any user accessing database while execiution of calc script in PROD? I hope users don't have access to Test instance so that may be the reason calc is running fast than in PROD.
Calc script is taking long time in EPM PROD, althoug its taking much less time in QA.
the cfg settings ,DB settigns, cache size, claccblock size all are same in PROD and QA.
PLease suggest to reduce the script timings