How Can we find which CMDB queries runs on current table

maddamsetti
Tera Contributor

Hello Community,

 

We have created a HI case with ServiceNow team for investigation of a ServiceNow notification table(custom table) which is loading very slowly if we try to open a new form on this table.

 

As per the Hi-Team case investigation they replicated this issue and noticed two slow queries that run slow in the database. As part of the investigation they implemented the Index hints to optimize those slow queries in the Dev instance. But still we haven't observed any improvement in the form loading time.

The slow query that they have noticed is being triggered by the 'CMDB-based recipients' relationship.

 

Could some one please help me to understand below points.

 

i) How we can check which queries are running on our table

ii) each query is taking how much time.

iii) What is the purpose of running that query on that table

iv)    Name of the CMDB queries involved
         Function of the CMDB queries involved which causes slowness as per the HI case in this situation.

 

 

 

1 REPLY 1

Community Alums
Not applicable

Hi @maddamsetti ,

Yu can find the queries by using below:

Filter navigator, enter qb_saved_query.list.

 

Purpose of running the quesry you need to figure out by looking at the query conditions as reason won't be mentioned .

Time taken for the query is also something you won't get directly, it's the ServiceNow support team who can run a health scan and tell you which query is taking more time.