How Resource Governor Works

Resource Governor monitors request activity, logging the attributes of each request and storing them in a usage-monitoring table. Once an adequate amount of usage monitoring data has been collected, you can run Resource Governor reports, which illustrate various aspects of request activity at your site. The process of choosing resource thresholds and building governing rules can then begin. Resource thresholds must be set before you can build automated or data rules. The rule parameters feature enables you to create shifts, which facilitate the application of date and time restrictions. Once those limits have been set, you can begin to build rules upon which data access will be governed.

At times, you may encounter certain conditions contained in requests that should never be allowed to run. In other cases, you may know that all queries should be allowed to run, such as those submitted by a user with greater privileges. On these occasions, you can create business rules with the Business Rule Builder to check for these kinds of conditions in order to generate cancellation messages, or allow beyond-threshold queries to run. When using business rules only, the selection of resource thresholds is not required. All data sources can be governed by data rules, business rules, or both.

You access the Resource Governor administrative and reporting features through the Web Console of the server.

An alternative form of governing that becomes available as soon as the product is installed, and does not require any monitoring of data requests, is governing with business rules only. Business rules syntax can be created with a New Business Rule while Add Rule for Governing can create a Rule File of Business Rule Type. This rule file may be assigned to any or all data sources, as well as globally for any data request.


WebFOCUS