This content has been marked as final. Show 10 replies
^^^SAN definition: http://en.wikipedia.org/wiki/Storage_area_network
i ma no clear what do you mean by SAN.
If you are sharing drives, and other users (or systems) are heavily drawing upon those drives, Essbase will reflect that usage.
^^^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
What kind of calc scrit it is?
Did u added any Dense members? If yes,What kind of restructure you have done?
Did u added any Sparse members? If yes,What kind of restructure you have done?
Have moved existing members or added new members?
Please let me know.
This is a perfect example of a situation where a holistic view of things is needed to really see what is going on. So many factors could be causing this. Could even be a combination of things.
A tool called Accelatis exists that can provide that view.
CL makes an excellent point about using a SAN or NAS. This is the type of storage in use for holding the essbase data. Essbase Calcs can really load up a data bus.
One quick thing to check on the prod server is the log sizes. If the logs are getting enormous, that can slow things down. The reason I say this, is classically people tend to review and truncate logs in the DEV/QA environments far more than in prod.
Look through the prod log and see if it indicates things happening that aren't happening in QA.
Is it possible that there are users in the system on Prod when you run your calc?