Managing the database maintenance tasks

The BMC Client Management database is hosted on Oracle, SQL Server and PostgreSQL. Optimize the database performance by scheduling the database maintenance tasks. Scheduling the tasks helps you to make sure that the database statistics and indexes are regularly updated. Consult your DBA to make sure that your database indexes and statistics are updated regularly. BCM Support recommends that you create the basic maintenance plans to schedule the maintenance tasks to run in the background. 

Related topics

Database-tuning

System-requirements

Database-installation-and-configuration

PostgreSQL-recommendations

Oracle Database Maintenance

For information about Oracle's automatic maintenance tasks, see Managing Automated Database Maintenance Tasks.

For information about Oracle recommendations and configuration, see Oracle-recommendations.

SQL Server Database Maintenance

For information about SQL Server's maintenance plan, see Create a Maintenance Plan and Use the Maintenance Plan Wizard. When you are creating a maintenance plan in SQL Server by using SQL Server Management Studio, you need to configure the options as described at SQL Server database maintenance recommendations.

PostgreSQL Database Maintenance

For information about PostgreSQL's maintenance plan, see Routine Database Maintenance Tasks.

The default configuration of PostgreSQL is set up for small servers. For a database with high volume of data and queries running on a powerful server, it is necessary to make some configuration changes. We recommend that you significantly increase the value of the shared_buffers and work_mem parameters which indicate the maximum amount of memory to be used for some operations. You can use the pgtune utility to find basic indications about the values to be used depending on the hardware configuration. For information about how to configure PostgreSQL database, see To configure the PostgreSQL database.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*