Resource Governor Reports

The Monitored Data Sources report provides an overview of the data sources that are being monitored, including number of requests, and the first and last access dates.

To access the Monitored Data Sources report in the Web Console, click Resource Management on the toolbar and expand the Reports folder. Right-click Monitored Data Sources, and select Run from the context menu. After specifying report filters, click View Report.

The following image shows the Monitored Data Sources report.

The Monitored Procedures report provides an overview of the procedures that are being monitored, including the number of executions, and the first and last execution dates.

To access the Monitored Procedures report in the Web Console, click Resource Management on the toolbar and expand the Reports folder. Right-click Monitored Procedures, and select Run from the context menu. After specifying report filters, click View Report.

The following image shows the Monitored Procedures report.

The Threshold Adviser Report shows parameter details of all Resource Governor thresholds that have been built.

The following image shows the Resource Thresholds report.

The Knowledgebase Properties Report shows details of all knowledge bases that have been built, the rule file used, and the status of the knowledge base.

The following image shows the Knowledgebase Properties report.

This report has two hyperlinks that allows you to drill down to other reports, as described in the following table.

The Threshold Advisor Report recommends thresholds based on statistical information derived from monitored data.

The following image shows the Threshold Advisor report.

This report shows which requests been governed or canceled and the rule file used to govern.

Governing Reports can be generated for particular data sources and user IDs, for all data sources and user IDs, or for combination of the two.

To access these reports in the Web Console, expand the Resource Governor folder in the tree, right-click Governed Requests and select Run. The Resource Management: Report filter for Governed Requests window opens, as shown in the following image. Here you can filter on data source name and/or user. Enter a valid data source name and/or user name to filter on, or enter ALL for all data sources and all users. The default is ALL.

The following image shows an example of the Governed Requests report.