Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-6238

Extremely slow SLA recalculation time when a Service Desk project contains a high number of issues

      Issue description

      When a Service Desk project contains a high number of issues (for example more than 20k), the SLA recalculation might get stuck or take a long time after editing an SLA configuration.

      Steps to reproduce

      • Create a Service Desk project with at least 20k open issues
      • Make a change to an existing SLA in the project via the page Project Settings > SLAs, in order to trigger the re-calculation of this SLA for the entire project

       Note that this issue has not been reproduced on Atlassian side, but it has been reported by some customers.

      Actual Result

      The SLA recalculation takes a lot of time to complete, and from the UI it looks like it's stuck since the progression bar does not seem to progress.
      Note that the time it takes for the recalculation to complete varies depending:

      • on the customer's environment
      • the length of the history of issues for which the SLA needs to be recalculated
      • the number of goals in the SLA configuration
      • the number of SLAs configured in the project

      Expected Result

      The recalculation of the SLA should be faster (although it is difficult to tell how long it should take as it depends on many factors, see above).

      Workaround

      No known workaround.

          Form Name

            [JSDSERVER-6238] Extremely slow SLA recalculation time when a Service Desk project contains a high number of issues

            How long should this take? Created a bunch of new SLA's (deleted the old ones) & waiting for 16 hours now to recalculate. Thank you for advising.

            Jana Jäger added a comment - How long should this take? Created a bunch of new SLA's (deleted the old ones) & waiting for 16 hours now to recalculate. Thank you for advising.

            Sven Laanela (Inactive) added a comment - - edited

            Hi,

            We have recently made improvements to JSD Server around SLA recalculation. You should see significantly improved performance in this area in JSD Server 4.2.

            Another optimisation that we are considering rolling out in upcoming versions of JSD Server is to allow SLA calculation run concurrently in multiple threads. However, before doing that, we would like to gather your feedback on how much of an improvement this provides. The parallel SLA recalculation is available on JSD version 4.3.2+ and can be enabled by using the

            sd.sla.parallel.recalculation

            feature flag.

            Please note the parallel SLA recalculation will use all available processor cores by default. This can be configured via the

            servicedesk.sla.recalculation.max.threads

            Jira application property if required.

            Please leave your feedback on this ticket and let us know if the above improvements have fixed or significantly improved the slow SLA recalculation problem for you.

            Sven Laanela (Inactive) added a comment - - edited Hi, We have recently made improvements to JSD Server around SLA recalculation. You should see significantly improved performance in this area in JSD Server 4.2 . Another optimisation that we are considering rolling out in upcoming versions of JSD Server is to allow SLA calculation run concurrently in multiple threads. However, before doing that, we would like to gather your feedback on how much of an improvement this provides. The parallel SLA recalculation is available on JSD version 4.3.2+ and can be enabled by using the sd.sla.parallel.recalculation feature flag. Please note the parallel SLA recalculation will use all available processor cores by default. This can be configured via the servicedesk.sla.recalculation.max.threads Jira application property if required. Please leave your feedback on this ticket and let us know if the above improvements have fixed or significantly improved the slow SLA recalculation problem for you.

            We experience this with only 83 issues and 20 SLA goals (which depend on Insight objects and different calendars). Recalculation is now running for 4 days!

            Thomas Heidenreich (//S) added a comment - We experience this with only 83 issues and 20 SLA goals (which depend on Insight objects and different calendars). Recalculation is now running for 4 days!

            bede added a comment -

            We experience this with much lower numbers of issues.. ie. one of the projects experiencing this contains 1830 issues. The  global volume of issues across all projects is much higher + we have 18 different SLA custom fields defined, each project using 2 or 3

             

            bede added a comment - We experience this with much lower numbers of issues.. ie. one of the projects experiencing this contains 1830 issues. The  global volume of issues across all projects is much higher + we have 18 different SLA custom fields defined, each project using 2 or 3  

            We have had the same issue, we have over 20k tickets in one project and we added some new SLA's rule and they just never recalculate. Admins if you want more feedback to our environment let me know. 

            Adam Janecke added a comment - We have had the same issue, we have over 20k tickets in one project and we added some new SLA's rule and they just never recalculate. Admins if you want more feedback to our environment let me know. 

              mreil1 Markus Reil (Inactive)
              jrey Julien Rey
              Affected customers:
              7 This affects my team
              Watchers:
              16 Start watching this issue

                Created:
                Updated:
                Resolved: