1497 views

Troubleshooting case where all users experience performance issues on a specific application




Symptoms
  • The instance is slow and sometimes unavailable. 
  • Semaphores appear to be locked or have long running times.
  • The Pool Sweeper cannot release long running database connections.
  • Low or out of memory alerts appear.
  • Localhost logs display a slow business rule message.
  • Loading a form takes too long or freezes before any interaction is possible.
  • High amount of browser time indicated in the Client Transaction Timing widget or log for a particular form transaction.

 

Cause
  • Inefficient queries executing in the database (MySQL).
  • Inefficient business rules being processed in the application.
  • Too many asynchronous JavaScript and XML (AJAX) calls generated by client scripts.

 

Resolution

 

PrerequisitePrerequisite:
Prior to completing the following steps, collect the necessary information needed to troubleshoot the performance issue. For more information, see Gathering node data via stats.do and threads.do

 

To troubleshoot slow performance experienced by all users on a specific application:

  1. Verify that there are no inefficient business rules being processed in the application. For more information, see Identifying and addressing inefficient business rules.
  2. Verify that a client script is not making too many asynchronous AJAX calls. For more information, see Identifying and reducing synchronous AJAX calls generated by client scripts.

 

The ServiceNow internal role is required to complete the following steps:

  1. Verify that there are no inefficient queries running against the database. For more information, see Identifying and tuning inefficient queries executing in the database (MySQL).

 

If the issue continues to exist after trying the steps in this article:

 

Additional Information

For more information on related topics, review the following ServiceNow product documentation pages:

For more topic related issues, review the following Knowledge Base article:

Article Information

Last Updated:2017-09-15 09:18:43
Published:2011-12-09