NumaNodeAffinity Enumeration
The NumaNodeAffinity enumeration defines the affinity states for a Cpu object.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
| Member name | Description | |
|---|---|---|
| Full | Affinity is set for all the T: Microsoft.SqlServer.Management.Smo.NumaNode.CPU objects that belong to the NumaNode object. | |
| None | Affinity is not set for any T: Microsoft.SqlServer.Management.Smo.NumaNode.CPU objects that belong to the NumaNode object. | |
| Partial | Affinity is set for some but not all the T: Microsoft.SqlServer.Management.Smo.NumaNode.CPU objects that belong to the NumaNode object. |
The following example shows how to set the affinity for each NUMA node in the local instance of SQL Server to T:Microsoft.SqlServer.Management.Smo.NumaNodeAffinity.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();
}
}
}
Show: