Reports with very long execution times.

[Meenal Gharat]

Hi All,

In the HealthScan Report it show there are more than 2000 reports running longer on average as 10000 milliseconds.

What are the possible steps or best practices to resolve this .

Also there are 2-3 reports which show No record to display yet it takes more than 10000 milliseconds of running time.

Any suggestions would be helpful.

Thanks and Regards,

Meenal

[Thomas_Davis]

Go to Reports > Administration > Report Statistics and it will show you the Recent run time for the reports that take the most time to run.

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/reporting/re...

Once you get the list, it really is going through them and understanding why the report is taking so long to run.  Look at the conditions in the report and see if they are trying to pull back an extended period of data based on time. Some could be pulling back many months or even years of data back.  Try to identify them and look at changing the date range of the report to reduce how much data is coming back to in return speed the running of the report up.

You can also look at the Report Usage dashboard to get an overview of how reports are used in your Instance to determine if some cleanup of those reports is needed.

Hope this gives you a starting point.

[Meenal Gharat]

Hi Thomas,

Thanks for the reply.

Best Regards,

Meenal 

[Thomas_Davis]

No problem, hope it helped.

[sachin_namjoshi]

Follow below steps to troubleshoot slow reports

 

 

Identify Slow Reports

- Go to Report Statistics module. 

1. 

2. Sort z->a platform list results by Recent run time. You can see the reports that take more time to execute on top of the list.

   

3. Identify the  slowest reports within your test instance.

Advanced performance querying per user

Use case: A report is slow but not for all users. find out the users whom the report is slow

1. Open report_executions list platform.

   

2. Search for Report with  which user has the biggest execution duration.

3. Identify the  users with highest execution duration.

For more info about Report statistics: Report statistics Documentation

Analyze performance issues

1. Open the Report overview by clicking View / Run in the Reports section. 

2. Identify report fields that could provoke slow performance (usually group by and stack by are the fields to check) and take note of them. Other possible issues could include the fields in the conditions.

   Note: A report using group by and or stacked by are more database expensive (to group fields the database server needs to read all data in a table).

3. Check if the table or database view contains an index for the group by and stack by fields.

Power of the Admin console

Note: The Admin console functionality requires a Performance Analytics license.

1. Navigate to Performance Analytics -> Admin Console

   

2. Click on Reports Usage link (under Usage Section)

   

3. Click on Report Usage tab

   

4. Answer for yourself, the following questions:

   a. how many reports do we have that uses report_source

   b. How many pie charts do we have?

   c. Is the number of reports increasing?

   d. Which are the 3 most used tables?

   e. Are my users using Report Sources?

   f. How many reports are using Report Sources?

   g. Are the number of reports using Report Sources increasing over time?

   h. Do I have scheduled reports? How many?

   i. Which is the least used Report Type?

   j. Which are the reports that have been run between 6-10 times?

   k. Is the number of reports used the last 6 months increasing? With what %?

Regards,

Sachin