Show TOC

Resource Governor (SQL Server)Locate this document in the navigation structure

Resource Governor, available in SQL Server 2008 and higher, lets you limit resource requests by workloads for CPU time and memory to optimize their allocation.

PowerDesigner supports Resource Governor through the following objects:

  • Workload groups – are containers for sets of similar session requests.

  • Resource pools – represent the physical resources of the server.


In this section:
    Workload Groups (SQL Server)
    A workload group serves as a container for session requests that are similar, to allow the aggregate monitoring of resource consumption and the application of a uniform policy to all the requests in the group. A group defines the policies for its members. PowerDesigner models workload group sas extended objects with a stereotype of <<WorkloadGroup>>.
    Resource Pools (SQL Server)
    A resource pool represents the physical resources of the server. PowerDesigner models resource pools as extended objects with a stereotype of <<ResourcePool>>.