Slow performance of instance.

[damirdoszhan]

Dear community!

Our instance is suffering from slow performance. There are many cases when running transactions exceed 200 seconds. In order to solve this problem we tried to configure cache, homepage performance and etc. This problem constantly occurs specifically for one group of users.   Thanks in advance!

[amlanpal]

Hi Damir,

Please refer the below article. This might be helpful for your issue:

Improve performance: database indexes and slow queries

I hope this helps.Please mark correct/helpful based on impact

[JC Moller]

Hi,

Have you at all managed to narrow down the issue? What type of transactions exceed 200 seconds - tickets to other integrations?

How many application nodes do you have and how large is the user base?

Do you have this issue also on your dev and test instances?

Can you find anything special in the Servicenow Performance Homepage meters' values, if you compare today's values to 30 day values?

Have a look at the Slow Queries, Scripts and Transactions under System Diagnostics in the Application Navigator.

Open the "Table IOStats" -link from the Application navigator or directly https://yourinstance/nav_to.do?uri=/v_iostats_list.do

Sort the "Selects Over 10s" column. Do you have some high counts in this column? This could indicate a issue with a missing index or some other cause. Worth looking into.

- Jan

[JC Moller]

Hi,

You could also run the following report to see how your instances' semaphores are used.

What type of values do you see? Most values in what range?

- Jan

[damirdoszhan]

Hi Jan!

Thank you for your response! Yes, I have checked IOstats table and there are some record which exceeds 0 for "Selects Over 10s", For instance, syslog_transaction. Also, in users' transaction logs there are many records which exceeds 10000 ms.

Currently, we are using demo instance, we are planning to migrate on proudcition instance next month. Could you help to find answer for this question? Thanks in advance!