ESC portal loading take a lot of time , once loaded it works fine

[IceIronDragon]

We are facing an issue where in the ESC portal takes 27 sec to load the home page and after that it works fine.

I inspected the page and this initiator is taking a lot of timne : 27sec

any idea how can we start troubleshooting this ?

[Ct111]

It could be having long running SQL queries , or auto refreshing widgets or probably there is lot of data displayed in menu items that can be causing it .

Check some of the recommendations given in this Servicenow support article and see if it helps

Link : https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0634588

Mark my Answer as CORRECT and Helpful if it helps

[IceIronDragon]

some one suggested to have index hints .

is it worth it or how do we add inde hints ?

[Ct111]

Hello, I am not sure what exactly you are referring towards

However, I came accross one post where there is a script in that which will help you to identify slow running widgets on your page.

Check this I hope it is helpful .

Link : https://community.servicenow.com/community?id=community_blog&sys_id=d678d26bdb81b7c414d6fb2439961970

Mark my Answer as CORRECT and Helpful if it works

[IceIronDragon]

thanks , 

my issue got solved by running index hints and union optimisation through query rewrite.