NumaNodes 属性
The NumaNode()()()() member is a collection that contains the NUMA node settings for an Instance of SQL Server.
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
Public ReadOnly Property NumaNodes As NumaNodeCollection
Get
用法
Dim instance As AffinityInfo
Dim value As NumaNodeCollection
value = instance.NumaNodes
public NumaNodeCollection NumaNodes { get; }
public:
property NumaNodeCollection^ NumaNodes {
NumaNodeCollection^ get ();
}
member NumaNodes : NumaNodeCollection
function get NumaNodes () : NumaNodeCollection
属性值
类型:Microsoft.SqlServer.Management.Smo. . :: . .NumaNodeCollection
Returns the NumaNodeCollection
注释
Access to the NumaNodes collection is provided though the [T:Microsoft.SqlServer.Management.Smo.AffinityInfo.] member of the Server object.
示例
This example reads the NUMA node settings on the local instance of SQL Server and displays the values of the AffinityMask, GroupID and
ID members.
using System;
using Microsoft.SqlServer.Management.Smo;
namespace samples
{
class Program
{
static void Main(string[] args)
{
Server dbServer = new Server("(local)");
dbServer.Refresh();
Console.WriteLine("Total Numa Nodes: {0}\n", dbServer.AffinityInfo.NumaNodes.Count);
foreach (NumaNode numaNode in dbServer.AffinityInfo.NumaNodes)
{
Console.WriteLine(
"numaNode.AffinityMask: {0} \n" +
"numaNode.GroupID: {1}\n" +
"numaNode.ID: {2} : IAlterable, IScriptable\n",
numaNode.AffinityMask,
numaNode.GroupID,
numaNode.ID);
}
}
}
}
Powershell
#Create the server.
$dbServer = new-Object Microsoft.SqlServer.Smo.Server("(local)")
$dbServer.Refresh()
Write-Host "Total Numa Nodes: Microsoft.SqlServer.Smo`n",
dbServer.AffinityInfo.NumaNodes.Count
Foreach ($numaNode in $dbServer.AffinityInfo.NumaNodes)
{
Write-Host $numaNode
}