CMDB_CI Table is running too slow

[Subhashini4]

Hi, 

cmdb_ci has more than 2M records. system is Taking around 150 seconds to load. and taking 180 seconds for cmdb reports.

Could you please suggest troubleshooting steps and steps  to reduce slowness? 

Thanks,

[Sulabh Garg]

Hello Subhashini,

why you want to load the cmdb_ci (2M) records frequently? you may try to load the filter first using below URL or write (cmdb_ci.filter) under left navigation and then filter the CI's based on the filters.

https://<Instancename>/nav_to.do?uri=%2Fcmdb_ci_list.do%3Fsysparm_filter_only%3Dtrue 

For detailed analysis on slowness, you need to raise HI for this and they should come back with the findings on your instance based on the load/traffic on the instance.

Hope it helps!!

Please Mark ✅ Correct/helpful, if applicable, Thanks!! 

Regards

Sulabh Garg

[Maik Skoddow]

Hi @Subhashini 

there are tons of reasons why opening a table can take so long, and without any more details or having a look into your instance it is difficult to guess anything.

I have a CMDB table with more than 3.4 million of records it is opening within 3 - 5 seconds. A simple option to speed up data loading is disabling the total number of records (see https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/list-admin...)

Also you should know that due to the architecture of ServiceNow you only can perform one action at a time and session. That means if you are opening a list with many records in one browser tab you cannot open a list from another table in parallel. In the second tab you have to wait for finishing the transaction in the first tab.

Kind regards
Maik