Slowness in accessing dashboards after an upgrade to 4000
Analysis:
CPU spikes to 100% and the pgsql.exe processes consuming more memory.
The phantom server which used to generate the snapshots for all the reports is enabled by default after the upgrade. This process creates load and causes the performance issue.
Solution:
1. Disable the generation of snapshots by modifying the property 'zrop
.snapshots.enabled' to false in ZROPAdvancedSettings table.
2. Restart the service.
Query:
- update ZROPAdvancedSettings set val='false' where key='zrop.snapshots.enabled'.