Try OpenEdge Now
skip to main content
Database Management
Database Resource Monitoring : Using the Configuration Advisor : Initiating the Configuration Advisor
 

Initiating the Configuration Advisor

To initiate the Configuration Advisor:
1. Click Resources > Go to Resources in the OpenEdge Management console menu.
All resources managed by your console appear in the grid frame.
2. Filter or search for, and select the database for which you want to initiate the Configuration Advisor.
The Database details page appears.
3. Click Configuration Advisor in the Command and Control section. The Configuration Advisor page appears:
4. In the Start Date and End date fields, define a date range that OpenEdge Management will use to collect data from the OpenEdge Management Trend Database. (The default date range is one week.)
5. In the Choose time period to analyze field, choose a time frame that defines a representative period of time in which the rules are generally active, or being used. This time frame is the period against which you want OpenEdge Management to calculate your baseline activity. (The default time period is Monday through Friday, 9:00 AM to 5:00 PM.)
Note: Your monitoring plan schedules are not necessarily the best choice for a time frame. A schedule defines a period of time in which rules are in effect; it does not focus on time periods in which your resource usage is highest. For example, you may use the default schedule (24 hours a day, 7 days a week) to monitor your system, but you may want to select Monday through Friday from 8:00 AM to 6:00 PM for calculating your baseline settings.
6. In the Select rules (for analysis) field, deselect any rules you do not want to analyze. The Configuration Advisor can analyze the following database resource rules:
*AIW Writes Percent Low
*BIW Writes Percent Low
*Buffer IO High
*Buffers Flushed at Checkpoint High
*Busy AI Buffer Waits High
*Busy BI Buffer Waits High
*Checkpoint Length Short
*Database Commits Low
*Empty AI Buffer Waits High
*Empty BI Buffer Waits High
Only rules associated with a monitoring plan appear in the Select rules (for analysis) list.
Note: If you added AI rules to a monitoring plan but do not have AI enabled on your database, do not select the AI rules for analysis.
7. Click Submit.
Note: Once you click Submit, you can browse to other OpenEdge Management pages and perform other tasks. You can return to the Configuration Advisor later to check the status and result details.
The Configuration Advisor calculates the threshold settings and reports the progress of each calculation it is performing. Depending upon the criteria that you set on the initial Configuration Advisor page, the number of rules you selected, and other factors such as your machine's speed, this calculation process can take time.
When the Configuration Advisor completes its calculations, the following page appears:
The following time period was used for analysis section of this page summarizes the values defined on the initial Configuration Advisor page. These values are displayed here to remind you of the time period criteria you set.
The Rule section contains all the rule-related calculated data. You can now review the Configuration Advisor's recommendations and choose whether or not to update your threshold values. See Understanding the recommended threshold settings for more information about the Configuration Advisor's calculated values.
Note: The Configuration Advisor page displays the calculated results data until you click either Update Selected Rules or Cancel.