NumaNode Class
The NumaNode object represents the settings for a NUMA node on an instance of SQL Server.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
| Name | Description | |
|---|---|---|
![]() | AffinityMask | Gets or sets the affinity type for the NUMA node represented by this NumaNode object. |
![]() | Cpus | Gets a collection of Cpu objects that belong to this NumaNode object. |
![]() | GroupID | Gets the T:Microsoft.SqlServer.Management.Smo.NumaNode.GroupID that is assigned to this NUMA node. |
![]() | ID | Gets the T:Microsoft.SqlServer.Management.Smo.NumaNode.ID of the NUMA node that is represented by this NumaNode object. |
| Name | Description | |
|---|---|---|
![]() | Equals(Object^) | (Inherited from Object.) |
![]() | GetHashCode() | (Inherited from Object.) |
![]() | GetType() | (Inherited from Object.) |
![]() | ToString() | (Inherited from Object.) |
Access to the NumaNode object is though the AffinityInfo object that is contained in the Server object.
The following example shows how to display all the NUMA nodes on the local instance of SQL Server and the CPUs that belong to each NUMA node.
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)
{
//Display the AffinityMask, GroupID and ID of
//each NUMA node.
Console.WriteLine("AffinityMask: {0}\n" +
"GroupID: {1}\n" +
"ID: {2}\n",
node.AffinityMask.ToString(),
node.GroupID, node.ID);
//Display the ID of each CPU that belongs
//to this NUMA node.
Console.Write("CPUS :");
foreach(Cpu cpu in node.Cpus)
Console.Write("{0} ", cpu.ID);
}
}
}
}
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

