September 2010
Intermediate to advanced
1704 pages
111h 8m
English
After you define your resource pools and workload groups, you need to create a classification function that contains the logic to evaluate the connections and assign them to the appropriate workload group. The classification function applies to each new session connection to SQL Server. Each session stays in the assigned workload group until it terminates, unless is it reassigned explicitly to a different group. There can be only one classification function active at any given time. If no classifier function is defined or active, all connections are assigned to the default workload group.
The classification function is a scalar function created with the CREATE FUNCTION statement, which must return a workgroup ...