Share via

  • Article

Méthode SetAffinityToRange (Int32, Int32, NumaNodeAffinity)

Sets the affinity mask for the NUMA nodes in the specified range.

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
Public Sub SetAffinityToRange ( _
    startNumaNodeId As Integer, _
    endNumaNodeId As Integer, _
    affinityMask As NumaNodeAffinity _
)
'Utilisation
Dim instance As NumaNodeCollection
Dim startNumaNodeId As Integer
Dim endNumaNodeId As Integer
Dim affinityMask As NumaNodeAffinity

instance.SetAffinityToRange(startNumaNodeId, _
    endNumaNodeId, affinityMask)

public void SetAffinityToRange(
    int startNumaNodeId,
    int endNumaNodeId,
    NumaNodeAffinity affinityMask
)

public:
void SetAffinityToRange(
    int startNumaNodeId, 
    int endNumaNodeId, 
    NumaNodeAffinity affinityMask
)

member SetAffinityToRange : 
        startNumaNodeId:int * 
        endNumaNodeId:int * 
        affinityMask:NumaNodeAffinity -> unit 

public function SetAffinityToRange(
    startNumaNodeId : int, 
    endNumaNodeId : int, 
    affinityMask : NumaNodeAffinity
)

Paramètres

  • startNumaNodeId
    Type : System. . :: . .Int32
    An int from 0 to Count -1 that specifies the beginning of the range of NUMA nodes. If startIndex is not within the valid range, the following exception is returned: Specified argument was out of the range of valid values. Parameter name: startIndex.
  • endNumaNodeId
    Type : System. . :: . .Int32
    An int that specifies the endIndex of the range. endIndex must be greater than or equal to startindex and less than [P:Microsoft.SqlServer.Management.Smo.NumaNodeCollection.Count.]
    If endIndex is not within the valid range, the following exception is returned: Specified argument was out of the range of valid values. Parameter name: endIndex.
    If endIndex is less than startIndex, the following exception is returned: The specified range of CPUs is not valid. The value for startIndex must be less than the value for endIndex.

Exemples

The following example shows how to set the affinity for each NUMA node on an instance of SQL Server.

using System;
using System.Collections.Specialized;
using System.Data;
using Microsoft.SqlServer.Management.Smo;

namespace samples
{
    class Program
    {
        static void Main(string[] args)
        {
            Server dbServer = new Server("(local)");
            dbServer.AffinityInfo.AffinityType = AffinityType.Manual;
            dbServer.AffinityInfo.NumaNodes.SetAffinityToRange(0,
                dbServer.AffinityInfo.NumaNodes.Count - 1,
                NumaNodeAffinity.Full);
            dbServer.AffinityInfo.Alter();
        }
    }
}