Database Reference
In-Depth Information
The value for the @resource_group_name variable is
default ; there is a reason for this specification. If, in case,
the Classifier function yields any invalid resource group then
the specified login will be set as a default group.
5. The next step is to activate the defined classifier function and enable
the configuration.
6.
For both of these tasks, we will use the ALTER RESOURCE GOVERNOR statement:
-- Assign the classifier function
ALTER RESOURCE GOVERNOR
WITH (CLASSIFIER_FUNCTION = dbo.SalesApp_PROD_classifier)
GO
--Enable the configuration
ALTER RESOURCE GOVERNOR RECONFIGURE
GO
7. You then need to perform a final check to see whether the classifier function is
enabled and working, by running the following statements:
SELECT*FROM sys.resource_governor_configuration
8.
The result will be:
Classifier_function_id is_enabled
1211151360
1
9. This step confirms that all the incoming application connections will be routed to the
appropriate workload groups and this will allocate relevant resources as per the user-
defined resource pools.
In order to collect the statistics for all the incoming application
connections, resource pools, and workload groups, you can query DMVs:
sys.dm_resource_governor_resource_pools
sys.dm_resource_governor_workload_groups
How it works...
The Resource Governor (RG) works on three fundamentals:
F Resource pools
F Workload groups
F Classification
 
Search WWH ::




Custom Search