We have 12 HFM applications in our HFM cluster. There is one big application out of 12. During busy time of the month the HFM performance gets pretty bad and all the applications are affected.
I am thinking to split applications in different HFM servers. Has anyone done this before ?
We have 2 servers Cluster (for load balance) in TEST and PROD env, in DEV we have a single server which has all the applications on one server. So the idea is to create 2 clusters. I am not sure how to approach this for better result.
The first question which I am trying to find answer for is : Do I need to create new HFM schema for the applications which I want to split ?
I have the below recommendations for you to improve the performance:
Please kill the following process and re-try.
1.The size of the hsveventlog file should not be more than 25 mb and if it grows beyond 25MB we would rename the existing hsveventlog file when no users are logged in and the HFM application/web servers are down so that a new file gets created on the re-start of the server.Perform the same to the hfm.odl.log as well
2.Check out the number of records in the HFM database tables <Applicationname>_DATA_AUDIT,<Applicationname>_TASK_AUDIT and HFM_ERROR_LOG table.
If the number of records is gone beyond 500,000 records in the above mentioned tables, please take a back up of the existing HFM Database and Truncate the records in it which would increase performance.
3.Ensure that the HFM management service on all the HFM application servers are kept in the stopped status.
4.Cross check the number of records in the HSV_ACTIVITY_SESSIONS table, let me know how much it returns
Also consider following the KB article Hyperion Financial Management (HFM) Performance Tuning Guide, Fusion Edition (Doc ID 1083460.1)