Article
02/09/2012

NumaNode Class

The NumaNode object represents the settings for a NUMA node on an instance of SQL Server.

Inheritance Hierarchy

System.Object
Microsoft.SqlServer.Management.Smo.NumaNode

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

Syntax

'Declaration
Public NotInheritable Class NumaNode
'Usage
Dim instance As NumaNode

public sealed class NumaNode

public ref class NumaNode sealed

[<SealedAttribute>]
type NumaNode =  class end

public final class NumaNode

The NumaNode type exposes the following members.

Properties

	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 GroupID that is assigned to this NUMA node.
	ID	Gets the ID of the NUMA node that is represented by this NumaNode object.

Top

Methods

	Name	Description
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	ToString	(Inherited from Object.)

Top

Remarks

Access to the NumaNode object is though the AffinityInfo object that is contained in the Server object.

Examples

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);
            }
        }
    }
}

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Share via