Microsoft® SQL Server 2012 Unleashed

Overview of Resource Governor

Resource Governor works by controlling the allocation of resources according to workloads. When a connection request is submitted to the Database Engine, the request is classified based on a classifier function. The classifier function is a scalar function that you define via T-SQL. The classifier function evaluates information about the connection (for example, login ID, application name, hostname, server role) to determine how it should be classified. After the connection request is classified, it is routed to a workload group defined for that classification (or if the connection cannot be classified, it is routed to the default workload group). Each workload group is associated with a resource pool. A resource ...