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 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. ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.