Maintaining your Jama Connect database
Follow these recommendations to maintain your Jama Connect database, which includes having a data backup plan and ensuring the appropriate memory is allocated to the database server.
Create a data backup plan — Back up your database server at least daily and implement backup strategies as needed.
Allocate appropriate memory to the database server — Have your Database Administrator monitor memory usage and allocate memory in advance to prevent running out of memory.
Configure system variables and server properties based on usage — For details, see the documentation for MySQL or SQL Server.
Check or analyze databases and tables every 6 months — We recommend that you review or analyze your databases at least every 6 months, or after you write, change, or delete a substantial amount of data. Pay extra attention to table or index size because Jama Connect is a write-heavy application. If a table has grown out of size or the index is too large, it might need to be rebuilt.
Use these resources to determine if an index or table must be rebuilt:
Leverage MySQL and SQL Server statistic gathering to detect the need to repair or analyze databases or tables.
Run mysqlcheck to check, repair, optimize, or analyze tables in MySQL. For details, see mysqlcheck — A Table Maintenance Program.
Use the Maintenance Plan Wizard tool to manage backups, data integrity checks, and statistic gathering in SQL Server. For details, see Use the Maintenance Plan Wizard.