资源调控器工作负荷组Resource Governor Workload Group

适用对象:是SQL Server 是Azure SQL 数据库(仅限托管实例)否Azure Synapse Analytics (SQL DW) 否并行数据仓库 APPLIES TO: yesSQL Server yesAzure SQL Database (Managed Instance only) noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

SQL ServerSQL Server 资源调控器中,工作负荷组充当具有相似分类标准的会话请求的容器。In the SQL ServerSQL Server Resource Governor, a workload group serves as a container for session requests that have similar classification criteria. 工作负荷允许对会话进行聚合监视,并定义会话的策略。A workload allows for aggregate monitoring of the sessions, and defines policies for the sessions. 每个工作负荷组均位于一个资源池中,它表示 数据库引擎Database Engine实例的部分物理资源。Each workload group is in a resource pool, which represents a subset of the physical resources of an instance of the 数据库引擎Database Engine. 在某个会话启动时,资源调控器分类器会将此会话分配给一个特定的工作负荷组,并且此会话必须使用分配给该工作负荷组的策略和为资源池定义的资源运行。When a session is started, the Resource Governor classifier assigns the session to a specific workload group, and the session must run using the policies assigned to the workload group and the resources defined for the resource pool.

工作负荷组概念Workload Group Concepts

工作负荷组是会话请求的容器,根据应用于每个请求的分类标准这些会话被认为是相似的。A workload group serves as a container for session requests that are similar according to the classification criteria that are applied to each request. 利用工作负荷组可对资源占用进行聚合监视并可将统一策略应用至组中的所有请求。A workload group allows 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.

备注

用户定义的工作负荷组可以从一个资源池移动到另一个资源池。User-defined workload groups can be moved from one resource pool to another.

资源调控器预定义了两个工作负荷组:内部组和默认组。Resource Governor predefines two workload groups: the internal group and the default group. 用户无法更改任何已归入内部组类的请求,但可以对其进行监视。A user cannot change anything classified as an internal group, but can monitor it. 当满足下列条件时,请求会被归入默认组类:Requests are classified into the default group when the following conditions exist:

  • 没有用于对请求进行分类的标准。There are no criteria to classify a request.

  • 曾经尝试将请求归入不存在的组类。There is an attempt to classify the request into a non-existent group.

  • 存在常规性的分类错误。There is a general classification failure.

资源调控器还提供了用于创建、更改和删除工作负荷组的 DDL 语句。Resource Governor also provides DDL statements for creating, changing, and dropping workload groups.

工作负荷组任务Workload Group Tasks

任务说明Task Description 主题Topic
说明如何创建工作负荷组。Describes how to create a workload group. 创建工作负荷组Create a Workload Group
说明如何更改工作负荷组设置。Describes how to change workload group settings. 更改工作负荷组设置Change Workload Group Settings
说明如何删除工作负荷组。Describes how to delete a workload group. 删除工作负荷组Delete a Workload Group

另请参阅See Also

资源调控器 Resource Governor
启用资源调控器 Enable Resource Governor
资源调控器资源池 Resource Governor Resource Pool
资源调控器分类器函数 Resource Governor Classifier Function
使用模板配置资源调控器 Configure Resource Governor Using a Template
查看资源调控器属性View Resource Governor Properties