SQL Server provides Resource Governor, a feature than you can use to manage SQL Server workload and system resource consumption. Resource Governor enables you to specify limits on the amount of CPU and memory that incoming application requests can use. In the context of Resource Governor, you can treat the preceding concepts as components. The following illustration shows these components and their relationship with each other as they exist in the database engine environment. From a processing perspective, the simplified flow is as follows: Session --- classified (Classification)---- Workload Group --- Resource pool ---- Application Definition: There is an incoming connection for a session (Session 1 of n). The session is classified (Classification). The session workload is routed to a workload group, for example, Group 4. The workload group uses the resource pool it is associated with, for example, Pool 2. The resource pool provides and limits the resources required by the application, for example, Application 3.
