Consolidation Performance Degraded
Has anyone had issues with sudden consolidation performance degradation? We are running on 9.3.1 with 2003 R2 SQL database server. (shared) and we started receiving the following error messages in HSVEvent logs: There were not enough connections in the SQL Connection Pool and FreeLRUCachesIfMoreRAMIsNeeded released data cubes. As a result, we increased the database connections in HFM from 80 to 150 and restarted both the database and HFM services. This did not help performance but did stop the SQL connection pool message. Has anyone else experienced anything such as this and how did you resolve the issue? No major changes
0