September 2010
Intermediate to advanced
1704 pages
111h 8m
English
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 classification function. The classification function is a scalar function that you define via T-SQL. The classification 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. ...