• Article

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> _
Public Property MaximumMemoryPercentage As Integer
    Get
    Set
'Usage
Dim instance As ResourcePool
Dim value As Integer

value = instance.MaximumMemoryPercentage

instance.MaximumMemoryPercentage = value

[SfcPropertyAttribute]
public int MaximumMemoryPercentage { get; set; }

[SfcPropertyAttribute]
public:
property int MaximumMemoryPercentage {
    int get ();
    void set (int value);
}

[<SfcPropertyAttribute>]
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