WorkloadGroup 类
The WorkloadGroup class is represents a SQL Server workgroup, which contains a group of session requests. Workload groups allow aggregate monitoring of resource consumption and application of uniform policies to all requests in the group.
继承层次结构
System. . :: . .Object
Microsoft.SqlServer.Management.Smo. . :: . .SmoObjectBase
Microsoft.SqlServer.Management.Smo. . :: . .SqlSmoObject
Microsoft.SqlServer.Management.Smo. . :: . .NamedSmoObject
Microsoft.SqlServer.Management.Smo. . :: . .ScriptNameObjectBase
Microsoft.SqlServer.Management.Smo..::..WorkloadGroup
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
<StateChangeEventAttribute("ALTER_WORKLOAD_GROUP", "WORKLOADGROUP", "WORKLOAD GROUP")> _
<StateChangeEventAttribute("CREATE_WORKLOAD_GROUP", "WORKLOADGROUP", "WORKLOAD GROUP")> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None Or AutomatedPolicyEvaluationMode.Enforce Or AutomatedPolicyEvaluationMode.CheckOnChanges Or AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute> _
Public NotInheritable Class WorkloadGroup _
Inherits ScriptNameObjectBase _
Implements ISfcSupportsDesignMode, ICreatable, IDroppable, IAlterable, _
IScriptable
用法
Dim instance As WorkloadGroup
[StateChangeEventAttribute("ALTER_WORKLOAD_GROUP", "WORKLOADGROUP", "WORKLOAD GROUP")]
[StateChangeEventAttribute("CREATE_WORKLOAD_GROUP", "WORKLOADGROUP", "WORKLOAD GROUP")]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None|AutomatedPolicyEvaluationMode.Enforce|AutomatedPolicyEvaluationMode.CheckOnChanges|AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[PhysicalFacetAttribute]
public sealed class WorkloadGroup : ScriptNameObjectBase,
ISfcSupportsDesignMode, ICreatable, IDroppable, IAlterable, IScriptable
[StateChangeEventAttribute(L"ALTER_WORKLOAD_GROUP", L"WORKLOADGROUP", L"WORKLOAD GROUP")]
[StateChangeEventAttribute(L"CREATE_WORKLOAD_GROUP", L"WORKLOADGROUP", L"WORKLOAD GROUP")]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::None|AutomatedPolicyEvaluationMode::Enforce|AutomatedPolicyEvaluationMode::CheckOnChanges|AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[PhysicalFacetAttribute]
public ref class WorkloadGroup sealed : public ScriptNameObjectBase,
ISfcSupportsDesignMode, ICreatable, IDroppable, IAlterable, IScriptable
[<SealedAttribute>]
[<StateChangeEventAttribute("ALTER_WORKLOAD_GROUP", "WORKLOADGROUP", "WORKLOAD GROUP")>]
[<StateChangeEventAttribute("CREATE_WORKLOAD_GROUP", "WORKLOADGROUP", "WORKLOAD GROUP")>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None|AutomatedPolicyEvaluationMode.Enforce|AutomatedPolicyEvaluationMode.CheckOnChanges|AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<PhysicalFacetAttribute>]
type WorkloadGroup =
class
inherit ScriptNameObjectBase
interface ISfcSupportsDesignMode
interface ICreatable
interface IDroppable
interface IAlterable
interface IScriptable
end
public final class WorkloadGroup extends ScriptNameObjectBase implements ISfcSupportsDesignMode, ICreatable, IDroppable, IAlterable, IScriptable
WorkloadGroup 类型公开以下成员。
构造函数
名称 | 说明 | |
---|---|---|
WorkloadGroup() () () () | Initializes a new, default instance of the WorkloadGroup class. | |
WorkloadGroup(ResourcePool, String) | Initializes a new instance of the WorkloadGroup class that has the specified name and resource pool. |
页首
属性
名称 | 说明 | |
---|---|---|
ExecuteForScalar | 获取或设置 Boolean 属性值,该值指定对象是否设置为针对标量选项执行。 (从 SqlSmoObject 继承。) | |
GroupMaximumRequests | Gets or sets the maximum number of requests that can be stored in the workload group. | |
ID | Gets the ID of the workload group. | |
Importance | Gets or sets a value that indicates the level of importance that the workload group has. | |
IsSystemObject | Gets a Boolean value that indicates whether the workload group is a system object. | |
IsTouched | 获取 Boolean 属性值,该值指定在服务器上对象属性是否已更新但尚未持久化。 (从 SqlSmoObject 继承。) | |
MaximumDegreeOfParallelism | Gets or sets the maximum degree of parallelism for the workload group. | |
Name | Gets or sets the name of the object. (从 NamedSmoObject 继承。) | |
ObjectInSpace | 获取 Boolean 属性值,该值指定对象是否单独存在,或者对象是否直接或间接连接到 SQL Server 的实例。 (从 SqlSmoObject 继承。) | |
Parent | Gets or sets the ResourcePool object that is the parent of the WorkloadGroup. | |
Properties | 获取表示对象属性的 Property 对象的集合。 (从 SqlSmoObject 继承。) | |
RequestMaximumCpuTimeInSeconds | Gets or sets the request maximum CPU time in seconds | |
RequestMaximumMemoryGrantPercentage | Gets or sets the request maximum memory grant percentage in seconds. | |
RequestMemoryGrantTimeoutInSeconds | Gets or sets the request memory grant time-out in seconds. | |
ScalarResult | 获取所引用对象的标量结果。 (从 SqlSmoObject 继承。) | |
State | Gets the state of the referenced object. (从 SmoObjectBase 继承。) | |
Urn | 获取唯一标识对象的统一资源名称 (URN) 地址值。 (从 SqlSmoObject 继承。) | |
UserData | Gets or sets user-defined data associated with the referenced object. (从 SmoObjectBase 继承。) |
页首
方法
页首
事件
名称 | 说明 | |
---|---|---|
PropertyChanged | 表示更改属性时发生的事件。 (从 SqlSmoObject 继承。) | |
PropertyMetadataChanged | 表示属性元数据更改时发生的事件。 (从 SqlSmoObject 继承。) |
页首
字段
名称 | 说明 | |
---|---|---|
m_ExtendedProperties | 表示一个属性,可以对该属性进行定义以便扩展 SqlSmoObject 提供的属性。 (从 SqlSmoObject 继承。) | |
singletonParent | 表示单一父级。 (从 SqlSmoObject 继承。) |
页首
显式接口实现
页首
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。