This content has been marked as final. Show 3 replies
Do you regularly defrag the databases? If not then I would give that a go and see how much it reduces the size, if it is still large then application design can be a factor
985935 wrote:A. Have u noticed .pag files are increasing while running B'rules?
I have a Hyperion Planning application with 9 dimensions. It came live on July last year. From then the users are submitting data and using the application. We have >both actuals and budget data. The page files have increased to 41. Because of this the performance has degraded significantly.
B. How many years of data does it contains? ("If it contains data from Jul'12 then problem with designing or dirty blocks")
C. Also go thru below link to understand "Limitations on size of dense dimensions for optimum performance" [Check Block size]
Better defrag the db and check .pag files..
I've built Planning apps (or just BSO databases) with 500K block sizes and while that wasn't my first choice it performed adequately.
My guess is as the above posters have noted:
1) You rarely, if ever, do a full restructure from MaxL or EAS. Try it (and if you are on 22.214.171.124, try the parallel restructure) but make sure you have (to be safe) a roughly equal amount of free space for Essbase to write out the defragmented (and removal of dead blocks) PAG files.
2) You have tons of data that you do not use. If it isn't used for budgeting, rip it out and stick it in a reporting cube.