Overview of Database Advisor processes


Database Advisor and other processes work together to collect data about your databases and environment, to analyze the data that is collected, and to recommend the best solution to correct reported problems.

Warning

Note

This section applies only to Database Advisor. Recovery Advisor processes differ from Database Advisor processes in important ways. For more information, see Overview-of-Recovery-Advisor-processes.

Collect, Analyze, and Solution processes are controlled by user-defined parameters and scheduled functions. BMC populates suggested defaults for most parameters, so you can begin using Database Advisor as soon as possible. The schedules that control Collect and Analyze processes for full-function and HALDB databases are activated by default. You must activate Collect and Analyze processes for Fast Path DEDBs explicitly (by selecting the RECON object in the tree, selecting Configure > Schedules, and editing the appropriate FP schedule).

The populated defaults make it easy for inexperienced DBAs to start using Database Advisor while learning more about sound data management practices. Using customization options, experienced DBAs can fine-tune parameters and schedules that control Database Advisor processes.

You can customize most parameters and schedules at most levels in the object tree, but BMC recommends that you start by specifying values at the host level. All subordinate levels inherit the values. You can customize subordinate levels at any time.

This section contains the following topics: 


 

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

BMC AMI Database Advisor for IMS 3.2