ResourcePool.MaximumMemoryPercentage Property
Gets or sets the maximum memory percentage for a Resource Pool.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property MaximumMemoryPercentage As Integer
Get
Set
'Usage
Dim instance As ResourcePool
Dim value As Integer
value = instance.MaximumMemoryPercentage
instance.MaximumMemoryPercentage = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public int MaximumMemoryPercentage { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property int MaximumMemoryPercentage {
int get ();
void set (int value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member MaximumMemoryPercentage : int with get, set
function get MaximumMemoryPercentage () : int
function set MaximumMemoryPercentage (value : int)
Property Value
Type: System.Int32
Int32
Remarks
A pool has two parts. One part does not overlap with other pools, which enables minimum resource reservation. The other part is shared with other pools, which supports maximum possible resource consumption. In this release of Resource Governor the pool resources are set by specifying one of the following for each resource:
Min or Max for CPU
Min or Max for Memory
See Also