Export (0) Print
Expand All

NumaNodeCollection.SetAffinityToRange Method (Int32, Int32, NumaNodeAffinity)

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

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

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

Parameters

startNumaNodeId
Type: 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: 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.
affinityMask
Type: Microsoft.SqlServer.Management.Smo.NumaNodeAffinity
The affinity mask value to set. The value must be one of the values listed for the NumaNodeAffinity. AffinityMask cannot be set to [E:Microsoft.SqlServer.Management.Smo.NumaNodeAffinity.Partial.]

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();
        }
    }
}
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft