Cpu Cpu Cpu Class

Definition

The Cpu class contains information about one CPU on an instance of SQL Server.

public ref class Cpu sealed
public sealed class Cpu
Public NotInheritable Class Cpu
Inheritance

Examples

The following code example displays the total number of CPUs on the local instance of SQL Server.

C#

using System;  
using Microsoft.SqlServer.Management.Smo;  

namespace samples  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Server dbServer = new Server("(local)");  
            Console.WriteLine(  
                "Total number of CPUs for server {0} is {1}.",  
                dbServer.Name,  
                dbServer.AffinityInfo.Cpus.Count);  
        }  
    }  
}  

Powershell

$dbServer = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  
Write-Host "Total number of CPUs for server" $dbServer.Name "is" $dbServer.AffinityInfo.Cpus.Count  

Remarks

Access to the Cpu class is though the Cpus collection property.

To change the CPU settings on an instance of SQL Server, users must have ALTER permission on the database.

Properties

AffinityMask AffinityMask AffinityMask

Gets or sets the AffinityMask member of the Cpu class.

GroupID GroupID GroupID

Gets the current value of the GroupID member.

ID ID ID

Gets the ID of the CPU that is represented by this Cpu object.

NumaNodeID NumaNodeID NumaNodeID

Gets the NumaNodeID of the NUMA node to which this Cpu object belongs.

Applies to