On-Premise Database Maintenance

Jira Align administrators that oversee on-premise deployments of the platform, for either 9X or 10X versions, should set up regularly scheduled maintenance of their Jira Align databases. We encourage regular database maintenance and offer the following recommendations.

Use the SQL Server Maintenance Plan Wizard to set up a basic maintenance routine, which could include the following:

  1. Database integrity check.
  2. Statistics update.
  3. Database backups, full and with transaction logs (Backing up the transaction log truncates the log and allows you to reuse the space; otherwise, the transaction log will continually grow).
  4. Maintenance cleanup of backup files and maintenance plan report files.

An example routine could look similar to this:

database_maintenance.png 

For a more intelligent and robust index maintenance plan, download the SQL Server Index and Statistics Maintenance script (© 2017 Ola Hallengren | E-mail: ola@hallengren.com | Sweden). Be sure to view the license and permissions notifications. 

Was this article helpful?
1 out of 1 found this helpful
Print Friendly Version of this pagePrint Get a PDF version of this webpagePDF

Join the Atlassian Community!

The Atlassian Community is a unique, highly collaborative space where customers and Atlassians come together. Ask questions and get answers, start discussions, and collaborate with thousands of other Jira Align customers. Visit the Jira Align Community Collection today.

Need to contact Jira Align Support? Please open a support request.