Urgent! Dashboard performance issue due to reports; way to identify transactions for slow dashboards

[ashwanikumar]

Hi All,

We have dashboards built for the uses which have multiple reports on it.

When user login, these dashboards loads slow and causes performance issue.

I have improved some reports conditions which improved the performance issue faced for some of the dashboards but I don't want to manually check all the dashboard & reports.

Is there a way to find dashboards which are taking loner time than usual to load? I could not find any transactions happening on logs for the dashboard load time.

[shawn_h]

Hi ashwanikumar,

The performance issues will definitely be coming from individual reports rather than dashboards themselves, which you've been rectifying. 

Your best bet is probably to check the Reports > Report Statistics module, then take a look at the Recent Run time of the reports in there. That should give you a list of the best targets for you to tackle next!

Good luck!

[Tsura Andreeva]

On my end I noticed that too many reports in one tab can cause slow response as well.

Suggestion would be to move some of the reports to another tab, that way they will only load when you view that tab.