Workload groups

Chapter 12 DBMS-Specific Features

Workload groups

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

Creating a workload group

You can create a workload group binding in any of the following ways:

Select Model→Workload groups to access the List of Workload Groups, and click the Add a Row tool.
Right-click the model or package in the Browser, and select New→Workload Group.

Workload group properties

You can modify an object's properties from its property sheet. To open a workload group property sheet, double-click its Browser entry.

The following extended attributes are available on the Microsoft tab:

Name	Description
Importance	Specifies the relative importance of a request in the workload group. Scripting name: Importance
Request maximum memory	Specifies the maximum amount of memory that a single request can take from the pool. Scripting name: RequestMaxMemoryGrantPercent
Request maximum CPU	Specifies the maximum amount of CPU time, in seconds, that a request can use. Scripting name: RequestMaxCpuTimeSec
Memory grant request timeout	Specifies the maximum time, in seconds, that a query can wait for a memory grant (work buffer memory) to become available. Scripting name: RequestMemoryGrantTimeoutSec
Maximum degree of parallelism	Specifies the maximum degree of parallelism (DOP) for parallel requests. Scripting name: MaxDop
Maximum requests	Specifies the maximum number of simultaneous requests that are allowed to execute in the workload group. Scripting name: GroupMaxRequests
Resource pool	Associates the workload group with the specified resource pool. Scripting name: ResourcePool