Reports in the Dashboard are loading dead slow, how to troubleshoot

Siddhant VSK
Tera Contributor

‎07-04-2024 09:55 PM

Hello Community,

I have a Dashboard which have loads of reports containing requested items , incidents.

This dashboard has reports consisting of data from past 12 months, 6 months, and various other timelines .

The Dashboard is taking allot of time to load , even more than 10 minutes at times.

Can you please help in how to tweak/troubleshoot this issue of lag in time to load the dashboard.

 

Thanks in advance,

Siddhant.

0 Helpfuls
  • 821 Views
1 REPLY 1

Satishkumar B
Giga Sage
Giga Sage

‎07-04-2024 09:59 PM - edited ‎07-04-2024 10:01 PM

Hi @Siddhant VSK 

 

To optimize dashboard loading time in ServiceNow:

1. Review Data Queries: Ensure queries are optimized, fetching only necessary data.

2. Reduce Widget Count: Limit widgets per dashboard to essentials for faster rendering.

3. Aggregate Data: Pre-aggregate data where possible to reduce real-time computation.

4. Scheduled Reports: Use scheduled reports for historical data to lighten real-time queries.

5. Performance Analytics: Utilize Performance Analytics to monitor and optimize dashboard performance.

Implementing these steps can significantly reduce dashboard load times.

 

----------------------------------------
If my response proves useful, please indicate its helpfulness by selecting "Accept as Solution" and " Helpful." This action benefits both the community and me.