It is clear that Resource Governor monitors how much work each group is doing. sys.dm_resource_governor_workload_groups makes this utterly obvious.
Suppose that:
- I don't yet trust my ability to classify my users into groups
- I want to begin by grouping my users without Resource Governor limiting their resources
- I want to monitor how much resources each group users
How would I achieve this?
My hunch is that this will work, but I don't trust myself with the Resource Governor yet. Did I miss anything?
CREATE WORKLOAD GROUP Group
USING [default];
GO
CREATE FUNCTION dbo.Classifier() <Do Whatever>
ALTER RESOURCE GOVERNOR WITH (CLASSIFIER_FUNCTION = dbo.Classifier);
GO
ALTER RESOURCE GOVERNOR RECONFIGURE;
GO

