Slow queries on incident_metric database views

Hamza Berouil2
Tera Guru

‎11-22-2017 03:06 AM

Hi all,

We are facing slowness issues when querying the OOB table incident_metric.

Almost 33 seconds to open the following list :

https://xxxxxx.service-now.com/incident_metric_list.do?sysparm_first_row=1&sysparm_query=md_name%3DI...

find_real_file.png

find_real_file.png

I had a look to the artcle Improve performance: database indexes and slow queries and tried to apply the recommandations, but I did not succeed to enhance the performance.

Well I am not confortable with mySql issues, maybe I have done things wrong.

In the meantime, I don't understand why we get slowness issues in OOB database view ? Shall we apply index table even if it's a OOB table ?

Any idea ?

Thank you

Preview file
7 KB
Preview file
54 KB
  • 1,399 Views
1 REPLY 1

San18
ServiceNow Employee
ServiceNow Employee

‎01-03-2018 11:42 AM

Hello Hamza,



Adding index definitely help. You can raise incident with Performance team to fine tune the sql.



Also try adding active = true in the filter might help to load faster.



Thanks


0 Helpfuls