CpuCollection Class
SQL Server 2012
The CpuCollection class represents a collection of Cpu objects that represent all the CPUs that are defined on an instance of SQL Server.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
The CpuCollection type exposes the following members.
| Name | Description | |
|---|---|---|
 | AffitinizedCPUs | Gets an affinitized Cpu list. |
| Count | Gets the number of Cpu entries in the collection. |
| IsSynchronized | Gets a value that indicates whether the collection is synchronized with the instance of SQL Server. |
| Item | Gets a Cpu object from the collection. |
| SyncRoot | Gets the synchronization root of the CpuCollection object. |
| Name | Description | |
|---|---|---|
| CopyTo(Array, Int32) | Copies the collection of objects to a one-dimensional array beginning at the specified index value. |
| CopyTo(Cpu[], Int32) | Copies the collection of objects to a one-dimensional array beginning at the specified index value. |
| Equals | (Inherited from Object.) |
| GetByID | Gets a Cpu object with the specified CPU ID from the collection. |
| GetElementAt | Gets a Cpu object from the specified position in the collection. |
| GetEnumerator | Gets a IEnumerator interface that can be used to iterate over the CpuCollection object. |
| GetHashCode | (Inherited from Object.) |
| GetType | (Inherited from Object.) |
| SetAffinityToAll | Sets the affinity mask for all CPUs on an instance of SQL Server. |
| SetAffinityToRange(Int32, Int32, Boolean) | Sets the affinity mask for the CPUs in the specified range. |
| SetAffinityToRange(Int32, Int32, Boolean, Boolean) | Sets the affinity mask for the CPUs in the specified range. |
| ToString | (Inherited from Object.) |
The following example shows how to display the ID of each CPU on an 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)");
dbServer.Refresh();
//Display the ID of each CPU on the instance of SQL Server.
foreach (Cpu cpu in dbServer.AffinityInfo.Cpus)
{
Console.WriteLine("Cpu ID = {0}", cpu.ID);
}
}
}
}
Powershell
$dbServer = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$dbServer.Refresh()
#Display the ID of each CPU on the instance of SQL Server.
Foreach ($cpu in $dbServer.AffinityInfo.Cpus)
{
Write-Host "CPU ID =" $cpu.ID
}
