Resource Governor Reporting
Once you have been monitoring data sources, you can
generate reports about the monitored data, rules, and canceled requests.
This chapter describes the various reports you can execute using
Resource Governor. For all platforms, Resource Governor reporting
is accessed from the Web Console.
Reports are organized into two primary groups. The general Report
section contains six reports about monitored data. The Resource
Governor reports folder contains the following reports:
-
Rule Parameters. Verify
current Resource Governor parameters for each data source.
-
View Rules. Shows
all rules for a data source, including automated rules created by
Resource Governor and business rules created by the administrator.
-
Threshold Advisor. Recommends
thresholds based on a statistical model.
-
Governed Requests. Shows
which remote procedures and ad hoc queries have been governed or
canceled and the rule file used to govern. The reports also show the
resources used for each query.
x
Procedure: How to Access Resource Governor Reports
To
access Resource Governor reports:
-
Launch the server's Web Console
-
Click Resource Management on the toolbar and
expand the Reports and Resource Governor folders,
as shown in the following image.
x
Procedure: How to Run Resource Governor Reports
To
run Resource Governor reports:
-
From the Web Console, expand the Reports folder
on the tree in the navigation pane.
-
Click the desired report in the tree, and select Run from
the context menu. The following image shows a Rule Parameters report
being run.
Note: In
addition to Run, the Reports context menu
also contains Run Deferred and List Deferred. Run
Deferred prompts you for a date and time to execute
the report and submits the report to the deferred queue. List
Deferred lists the procedures that are deferred.