Classe 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.
Hiérarchie d'héritage
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
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
<StateChangeEventAttribute("CREATE_WORKLOAD_GROUP", "WORKLOADGROUP", "WORKLOAD GROUP")> _
<StateChangeEventAttribute("ALTER_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
'Utilisation
Dim instance As WorkloadGroup
[StateChangeEventAttribute("CREATE_WORKLOAD_GROUP", "WORKLOADGROUP", "WORKLOAD GROUP")]
[StateChangeEventAttribute("ALTER_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"CREATE_WORKLOAD_GROUP", L"WORKLOADGROUP", L"WORKLOAD GROUP")]
[StateChangeEventAttribute(L"ALTER_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("CREATE_WORKLOAD_GROUP", "WORKLOADGROUP", "WORKLOAD GROUP")>]
[<StateChangeEventAttribute("ALTER_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
Le type WorkloadGroup expose les membres suivants.
Constructeurs
| Nom | Description | |
|---|---|---|
.gif "Méthode publique") |
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. |
Haut de la page
Propriétés
| Nom | Description | |
|---|---|---|
.gif "Propriété publique") |
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. |
|
MaximumDegreeOfParallelism | Gets or sets the maximum degree of parallelism for the workload group. |
|
Name | Gets or sets a String which contains the name of the WorkloadGroup. (remplace NamedSmoObject.Name.) |
|
Parent | Gets or sets the ResourcePool object that is the parent of the WorkloadGroup. |
|
Properties | Gets a collection of Property objects that represent the object properties. (hérité de 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. |
|
State | Gets the state of the referenced object. (hérité de SmoObjectBase.) |
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (hérité de SqlSmoObject.) |
|
UserData | Gets or sets user-defined data associated with the referenced object. (hérité de SmoObjectBase.) |
Haut de la page
Méthodes
| Nom | Description | |
|---|---|---|
|
Alter | Updates any WorkloadGroup object property changes on the instance of SQL Server. |
|
Create | Creates a workload group on the instance of SQL Server as defined by the WorkloadGroup object. |
|
Discover | Discovers a list of type Object. (hérité de SqlSmoObject.) |
|
Drop | Drops the workload group. |
|
Equals | (hérité de Object.) |
.gif "Méthode protégée") |
FormatSqlVariant | Formats an object as SqlVariant type. (hérité de SqlSmoObject.) |
|
GetContextDB | Gets the context database that is associated with this object. (hérité de SqlSmoObject.) |
|
GetDBName | Gets the database name that is associated with the object. (hérité de SqlSmoObject.) |
|
GetHashCode | (hérité de Object.) |
|
GetPropValue | Gets a property value of the SqlSmoObject object. (hérité de SqlSmoObject.) |
|
GetPropValueOptional | Gets a property value of the SqlSmoObject object. (hérité de SqlSmoObject.) |
|
GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. (hérité de SqlSmoObject.) |
|
GetServerObject | Gets the server of the SqlSmoObject object. (hérité de SqlSmoObject.) |
|
GetType | (hérité de Object.) |
|
Initialize() | Initializes the object and forces the properties be loaded. (hérité de SqlSmoObject.) |
|
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (hérité de SqlSmoObject.) |
|
IsObjectInitialized | Verifies whether the object has been initialized. (hérité de SqlSmoObject.) |
|
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (hérité de SqlSmoObject.) |
|
MoveToPool | Moves the workload group to the specified resource pool. |
|
Refresh | Refreshes the script name. (hérité de ScriptNameObjectBase.) |
|
Script() | Generates a Transact-SQL script that can be used to re-create the workload group. |
|
Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the workload group as specified by the script options. |
|
ScriptMoveToPool | Generates a script to move the workload group to the specified resource pool. |
|
SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. (hérité de SqlSmoObject.) |
|
ToString | Returns a String that represents the referenced object. (hérité de SqlSmoObject.) |
|
Validate | Validates the state of an object. (hérité de SmoObjectBase.) |
Haut de la page
Événements
| Nom | Description | |
|---|---|---|
.gif "Événement public") |
PropertyChanged | Represents the event that occurs when a property is changed. (hérité de SqlSmoObject.) |
|
PropertyMetadataChanged | Represents the event that occurs when property metadata changes. (hérité de SqlSmoObject.) |
Haut de la page
Implémentations d'interfaces explicites
| Nom | Description | |
|---|---|---|
.gif "Implémentation d'interface explicite") .gif "Méthode privée") |
IAlienObject.Discover | Discovers any dependencies. Ne faites pas directement référence à ce membre dans votre code. Il prend en charge l'infrastructure SQL Server. (hérité de SqlSmoObject.) |
|
IAlienObject.GetDomainRoot | Returns the root of the domain. (hérité de SqlSmoObject.) |
|
IAlienObject.GetParent | Gets the parent of this object. Ne faites pas directement référence à ce membre dans votre code. Il prend en charge l'infrastructure SQL Server. (hérité de SqlSmoObject.) |
|
IAlienObject.GetPropertyType | Gets the type of the specified property. (hérité de SqlSmoObject.) |
|
IAlienObject.GetPropertyValue | Gets the value of the specified property. (hérité de SqlSmoObject.) |
|
IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. Ne faites pas directement référence à ce membre dans votre code. Il prend en charge l'infrastructure SQL Server. (hérité de SqlSmoObject.) |
|
IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (hérité de SqlSmoObject.) |
|
IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. (hérité de SqlSmoObject.) |
|
IAlienObject.SetPropertyValue | Sets the property value. (hérité de SqlSmoObject.) |
|
ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. (hérité de SqlSmoObject.) |
.gif "Propriété privée") |
ISfcSupportsDesignMode.IsDesignMode | Gets a Boolean value that specifies whether the WorkloadGroup object supports design mode. |
Haut de la page
Notes
For more information on workload groups, see Concepts du gouverneur de ressources.
Sécurité des threads
Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.
Voir aussi
Référence
Espace de noms Microsoft.SqlServer.Management.Smo