O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a Classifier Function

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 classifier 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 classifier function active at any given time. If no classifier function is defined or active, all connections are assigned to the default workload group.

The classifier function is a scalar function created with the CREATE FUNCTION statement, which must return a workgroup name as value ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required