Resource Governor Operations

The following table lists and describes the basic operations of Resource Governor and the steps you need to take to use them. A detailed explanation of each operation is provided later in this manual.

Operation

Description

Collect data about the system.

Turn on usage monitoring for your site. Resource Governor then records the requests and the data about resource usage.

Describe resource thresholds for various time periods.

Enter the relative resource thresholds to set limits on the amount of resources each request can use. Monitored resources include elapsed and CPU time, IOs, and the number of result rows returned to the client. These thresholds help determine which requests can run during a specific time period.

Create rules.

Use Resource Governor to create a rule file. Resource Governor then uses these rules to evaluate each request and predict whether the request operates within the thresholds specified.

Turn Governing on.

Put governing rules into effect for each data source governed.

Govern data source access.

Every time a request uses a monitored data source, Resource Governor predicts whether the request exceeds thresholds based on the rules it has created. The only requests that are allowed to run are those estimated to use lower or equal amounts of threshold time, result rows, and IOs. Requests that are estimated to exceed the thresholds are canceled.

Apply site-specific business rules to add query limitations.

Customize governing to prevent or allow data access under specific conditions.


WebFOCUS