NumaNodeAffinity Enumeration
The NumaNodeAffinity enumeration defines the affinity states for a Cpu object.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Enumeration NumaNodeAffinity
'Usage
Dim instance As NumaNodeAffinity
public enum NumaNodeAffinity
public enum class NumaNodeAffinity
type NumaNodeAffinity
public enum NumaNodeAffinity
Members
| Member name | Description | |
|---|---|---|
| Full | Affinity is set for all the CPU objects that belong to the NumaNode object. | |
| None | Affinity is not set for any CPU objects that belong to the NumaNode object. | |
| Partial | Affinity is set for some but not all the CPU objects that belong to the NumaNode object. |
Examples
The following example shows how to set the affinity for each NUMA node in the local instance of SQL Server to Full affinity.
using System;
using Microsoft.SqlServer.Management.Smo;
namespace samples
{
class Program
{
static void Main(string[] args)
{
Server dbServer = new Server("(local)");
dbServer.Refresh();
foreach (NumaNode node in dbServer.AffinityInfo.NumaNodes)
node.AffinityMask = NumaNodeAffinity.Full;
dbServer.Alter();
}
}
}