Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-72366

[Documentation] Include recommendation to run DB maintenance job daily

XMLWordPrintable

      Problem Definition

      MSSQL and PostgreSQL DBs require to run maintenance job regularly to update statistics on the database. Not doing this leads to using the wrong plan by the query optimizer and this later causes slow performance for Select queries. See JSWSERVER-15917 and JRASERVER-63002 as an example.

      Quote

      Our DBA is updating the statistics on the two tables every hour between the hours of 6am and 11:59:59PM. He was also more aggressive in the index maintenance that runs nightly at 2am performing more index rebuilds (which automatically updates all statistics on the table the index supports) instead of performing index reorgs.

      Suggested Solution

      Update the "Connecting Jira applications to a database" docs, specifically pages:

      and mentioned the need to run maintenance job daily.
      We can use examples from related KB: https://confluence.atlassian.com/kb/optimize-and-improve-postgresql-performance-with-vacuum-analyze-and-reindex-885239781.html

      for MS SQL:

      Daily for hot tables - UPDATE STATISTICS <table.name>
Weekly for all Jira DB - UPDATE STATISTICS with fullscan;

      Workaround

      None

          Form Name

            [JRASERVER-72366] [Documentation] Include recommendation to run DB maintenance job daily

            Kunal Kishore made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 730275 ]
            Steven de Groot made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 715078 ]
            John Chin made changes -
            Affects Version/s New: 8.20.8 [ 99495 ]
            set-jac-bot made changes -
            Fixed in Long Term Support Release/s New: [Download 8.5|https://confluence.atlassian.com/enterprise/atlassian-enterprise-releases-948227420.html]
            Oksana Levchuk made changes -
            Fix Version/s New: 8.5.0 [ 87493 ]
            Fix Version/s New: 8.9.0 [ 91604 ]
            Fix Version/s New: 8.13.0 [ 92100 ]
            Fix Version/s New: 8.21.0 [ 97591 ]
            Oksana Levchuk made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: In Progress [ 3 ] New: Closed [ 6 ]
            Bugfix Automation Bot made changes -
            Support reference count Original: 25 New: 26
            SET Analytics Bot made changes -
            UIS Original: 74 New: 78
            Bugfix Automation Bot made changes -
            Support reference count Original: 24 New: 25
            SET Analytics Bot made changes -
            UIS Original: 79 New: 74

              bc878d9874ad Oksana Levchuk
              ayakovlev@atlassian.com Andriy Yakovlev [Atlassian]
              Affected customers:
              2 This affects my team
              Watchers:
              20 Start watching this issue

                Created:
                Updated:
                Resolved: