Jira Performance Issues Related to Multiple Issue Views Open at the Same Time

    Problem

    In some cases, whenever a lot of users navigate to view issue screens at the same time, Jira's performance goes down seemingly due to a deluge of SQL queries.

    Cause

    Every time you have an open tab with the issue view, Exalate will send the requests to the database to check for the sync status of the issue. Exalate queries the database anyway, no matter if the issue is under sync or not. The longer the issue stays in an open tab without refreshing, the rarer the requests are getting sent.

    Solution

    You can resolve the issue during peak hours by trying the following workaround:

    1. Navigate to Addons -> Manage Apps and open Exalate
    2. Click on the list of enabled modules

    3. Find the Sync Status Issue Panel module and click Disable

    4. Find the Exalate Originating Issue Tab module and click Disable

      Disabling the Sync Status Issue Panel and Exalate Originating Issue Tab modules will prevent database performance issues.