AffinityInfo.Refresh Method
This method fills in the Cpus and NumaNode with the local server settings.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Overrides Sub Refresh
'Usage
Dim instance As AffinityInfo
instance.Refresh()
public override void Refresh()
public:
virtual void Refresh() override
abstract Refresh : unit -> unit
override Refresh : unit -> unit
public override function Refresh()
Remarks
To set any AffinityInfo object properties and users must have ALTER permission on the database.
Examples
This example shows you how to determine the number of CPUs on the local instance of SQL Server.
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 CPUs = {0}",
dbServer.AffinityInfo.Cpus.Count);
}
}
}
Powershell
//Create the server.
$dbServer = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
//Set the Affinity Type to Auto
#dbServer.AffinityInfo.Refresh()
Write-Host "Total CPUs = ",$dbServer.AffinityInfo.Cpus.Count