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

[Documentation] Include recommendation to run DB maintenance job daily

    XMLWordPrintable

Details

    Description

      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

      Attachments

        Issue Links

          Activity

            People

              bc878d9874ad Oksana Levchuk (Inactive)
              ayakovlev@atlassian.com Andriy Yakovlev [Atlassian]
              Votes:
              2 Vote for this issue
              Watchers:
              20 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: