In this section: |
Before Resource Governor can monitor request information, it must know your monitoring requirements. You specify these requirements through the Resource Governor Administrator in the Web Console. You can specify a range of monitoring configurations depending on your needs.
The following image shows the Resource Management Web Console tool.
The monitoring process works as follows:
For more information on Usage Monitoring, see Resource Governor Administration.
Due to changing usage patterns, over time you may find that usage-monitoring data that has accumulated is no longer relevant to your current activity and analysis. When this is the case, Resource Governor allows you to delete this data from the usage monitoring table, by using the Resource Governor Administrator.
For more information about using the Resource Governor Administrator to set monitoring configurations and delete data, see Resource Governor Administration.
Before Resource Governor can create the rules that establish limits on the amount of resources each request can use, you must provide information about permissible resource thresholds at your site and the shifts that control requests made by end users. Resource Governor uses these thresholds and shifts, along with the previously collected usage monitoring data, to build rules about how requests will be governed against specific data sources. To create these thresholds, you use Rule Parameters. Based on these rules, the Resource Governor governing facility decides if a request can execute or not. For more information, see Resource Governor Administration.
Before Resource Governor can begin governing queries, you must first generate the rules to be used for that process. The rules generated by Resource Governor are based on usage monitoring data and the types of requests that have been monitored before governing is turned on. Business rules may be added without any prior monitoring of requests. When a request is issued, Resource Governor examines the request and uses the rules to determine whether that request should be permitted to execute. For more information about creating, editing, or deleting rules, see Resource Governor Administration.
You may be aware of certain conditions under which a request should never be allowed to run. However, if these conditions do not occur during the representative sampling of your site applications, they will not become part of the automated Resource Governor rules. Likewise, you may know of certain conditions under which all queries should be allowed to run, such as a user ID with greater privileges. The Business Rule Builder enables Resource Governor to govern immediately on conditions that are known to be unacceptable or that should never be canceled. It also lets you designate more specific parameters beyond simply the time and row number thresholds specified in the Rule Parameters view.
For example, you can configure Resource Governor to govern based on the particular data source being queried, the user ID submitting the request, or even a particular field within the request. Business rules allow for flexibility upon configuration of Resource Governor or changing Information System conditions at your site. Resource Governor uses its proprietary Business Rule Language (BRL) when building rules. For more information about BRL, see Business Rule Language (BRL).
For more information on creating business rules, see Creating Business Rules.
Resource Governor offers several types of reports, which show, among other things, a summary of monitoring data, a log of canceled queries, and rules.
You can re-sort reports by different columns and drill down on various hyperlinks to view more detailed information and different reports.
You can also specify date-range selection criteria for the reports by accessing a calendar through the Reports Preferences page. These reports are accessed from the Web Console. For more information on each individual report, see Resource Governor Reports.
The following table lists the report areas and names, and describes the different reports:
Report Area |
Report Name |
Report Description |
---|---|---|
Reports |
Monitored Sessions |
Shows the number of connections and amount of resources used. |
Monitored Commands |
Shows the number of commands, as well as how many were used and how many resources are consumed. | |
Monitored Data Sources |
Shows the number of data sources, as well as how many were used and how many resources are consumed. | |
Monitored Procedures |
Shows the number of times and what procedures, or FOCEXECS, are used with the resources consumed. | |
Data Sources Never Used |
Shows the list of application directories with MASTER file names, as well as the last date and time they were used. | |
Procedures Never Used |
Shows the list of application directories with FOCEXEC file names, as well as the last date and time they were used. | |
Resource Governor Reports |
Rule Parameters |
Shows the current state of governing parameters (shifts and thresholds). |
View Rules |
Shows all rules for data sources, including automated rules created by Resource Governor, and business rules created by the administrator. | |
Threshold Adviser |
Recommends resource thresholds based on a statistical model. | |
Governed Requests |
Shows all requests canceled by Resource Governor |
For more information on running and viewing these reports, see Resource Governor Reports.
WebFOCUS |