ResourcePool Class
SQL Server 2012
No content here will be updated; please do not add material here.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
[PhysicalFacetAttribute] [StateChangeEventAttribute(L"CREATE_RESOURCE_POOL", L"RESOURCEPOOL", L"RESOURCE POOL")] [StateChangeEventAttribute(L"ALTER_RESOURCE_POOL", L"RESOURCEPOOL", L"RESOURCE POOL")] [EvaluationModeAttribute(AutomatedPolicyEvaluationMode::None|AutomatedPolicyEvaluationMode::Enforce|AutomatedPolicyEvaluationMode::CheckOnChanges|AutomatedPolicyEvaluationMode::CheckOnSchedule)] public ref class ResourcePool sealed : public ScriptNameObjectBase, ISfcSupportsDesignMode, ICreatable, IDroppable, IAlterable, IScriptable
The ResourcePool type exposes the following members.
| Name | Description | |
|---|---|---|
.gif?cs-save-lang=1&cs-lang=cpp "Public method") | ResourcePool() | Initializes a new instance of the ResourcePool class. |
| ResourcePool(ResourceGovernor, String) | Initializes a new instance of the ResourcePool class. |
| Name | Description | |
|---|---|---|
.gif?cs-save-lang=1&cs-lang=cpp "Public property") | CapCpuPercentage | Gets or sets the CAP CPU percentage. |
| ID | Gets the resource pool identifier. |
| IsSystemObject | Gets a value the indicates whether the database is a system object or a user-defined database. |
| MaximumCpuPercentage | Gets or sets the maximum CPU percentage for a Resource Pool. |
| MaximumMemoryPercentage | Gets or sets the maximum memory percentage for a Resource Pool. |
| MinimumCpuPercentage | Gets or sets the minimum CPU percentage for a Resource Pool. |
| MinimumMemoryPercentage | Gets or sets the minimum memory percentage for a Resource Pool. |
| Name | Gets or sets the name of the object. (Overrides NamedSmoObject::Name.) |
| Parent | Gets or sets the Resource Pool Parent object, in this case a ResourceGovernor. |
| Properties | Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.) |
| ResourcePoolAffinityInfo | Gets the resource pool affinity info. |
| State | Gets the state of the referenced object. (Inherited from SmoObjectBase.) |
| Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.) |
| UserData | Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.) |
| WorkloadGroups | Gets or sets a Workload Groups collection associated with a Resource Pool. |
| Name | Description | |
|---|---|---|
| Alter | Alters a resource pool. |
| Create | Creates a user-defined Resource Pool. |
| Discover | Discovers a list of type Object. (Inherited from SqlSmoObject.) |
| Drop | Removes a Resource Pool from the collection. |
| Equals | (Inherited from Object.) |
.gif?cs-save-lang=1&cs-lang=cpp "Protected method") | FormatSqlVariant | Formats an object as SqlVariant type. (Inherited from SqlSmoObject.) |
| GetContextDB | Gets the context database that is associated with this object. (Inherited from SqlSmoObject.) |
| GetDBName | Gets the database name that is associated with the object. (Inherited from SqlSmoObject.) |
| GetHashCode | (Inherited from Object.) |
| GetPropValue | Gets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.) |
| GetPropValueOptional | Gets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.) |
| GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.) |
| GetServerObject | Gets the server of the SqlSmoObject object. (Inherited from SqlSmoObject.) |
| GetType | (Inherited from Object.) |
| Initialize() | Initializes the object and forces the properties be loaded. (Inherited from SqlSmoObject.) |
| Initialize(Boolean) | Initializes the object and forces the properties be loaded. (Inherited from SqlSmoObject.) |
| IsObjectInitialized | Verifies whether the object has been initialized. (Inherited from SqlSmoObject.) |
| IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (Inherited from SqlSmoObject.) |
| Refresh | Refreshes the resource pool. (Overrides ScriptNameObjectBase::Refresh().) |
| Script() | Creates a Transact-SQL statement to be run as a script. |
| Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the Resource Pool by using the specified options. |
| SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. (Inherited from SqlSmoObject.) |
| ToString | Returns a String that represents the referenced object. (Inherited from SqlSmoObject.) |
| Validate | Validates the state of an object. (Inherited from SmoObjectBase.) |
| Name | Description | |
|---|---|---|
.gif?cs-save-lang=1&cs-lang=cpp "Public event") | PropertyChanged | Represents the event that occurs when a property is changed. (Inherited from SqlSmoObject.) |
| PropertyMetadataChanged | Represents the event that occurs when property metadata changes. (Inherited from SqlSmoObject.) |
| Name | Description | |
|---|---|---|
.gif?cs-save-lang=1&cs-lang=cpp "Explicit interface implemetation") .gif?cs-save-lang=1&cs-lang=cpp "Private method") | IAlienObject::Discover | Discovers any dependencies. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.) |
| IAlienObject::GetDomainRoot | Returns the root of the domain. (Inherited from SqlSmoObject.) |
| IAlienObject::GetParent | Gets the parent of this object. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.) |
| IAlienObject::GetPropertyType | Gets the type of the specified property. (Inherited from SqlSmoObject.) |
| IAlienObject::GetPropertyValue | Gets the value of the specified property. (Inherited from SqlSmoObject.) |
| IAlienObject::GetUrn | Gets the Unified Resource Name (URN) of the object. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.) |
| IAlienObject::Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (Inherited from SqlSmoObject.) |
| IAlienObject::SetObjectState | Sets the object state to the specified SfcObjectState value. (Inherited from SqlSmoObject.) |
| IAlienObject::SetPropertyValue | Sets the property value. (Inherited from SqlSmoObject.) |
| ISfcPropertyProvider::GetPropertySet | Gets the interface reference to the set of properties of this object. (Inherited from SqlSmoObject.) |
.gif?cs-save-lang=1&cs-lang=cpp "Private property") | ISfcSupportsDesignMode::IsDesignMode | Indicates whether the resource pool supports design mode. |
