HFM: Performance Tuning on Application
There are three Planning Applications (seven Plan Types) are already there in Production, all perform well. After HFM was migrated from SIT to the Production environment recently, we immediately noticed the performance of HFM is not well. Normally it takes 15 seconds to open a HFM application in SIT, in production it takes over a minute to open (if after the services are recycled, it takes more than four minutes to open a HFM application). However, the consolidation time is sort of normal. (two to five minutes to consolidate a month, which contains about 400K of records). Following is the list of tuning activities, with regards to HFM tuning - 1) From DB side a) Ask DBA to confirm that Auto Create Statistics is enabled for the HFM schema. b) Have DBA check how frequently the SQL Server is doing automatic statistics maintenance. c) Ask the DBA if the indexes may need to be defraged. DBA reported back - a) Auto Create Statistics are enabled for all the