Метод CpuCollection.SetAffinityToAll
Sets the affinity mask for all CPUs on an instance of SQL Server.
Пространство имен: Microsoft.SqlServer.Management.Smo
Сборка: Microsoft.SqlServer.Smo (в Microsoft.SqlServer.Smo.dll)
Синтаксис
'Декларация
Public Sub SetAffinityToAll ( _
affinityMask As Boolean _
)
'Применение
Dim instance As CpuCollection
Dim affinityMask As Boolean
instance.SetAffinityToAll(affinityMask)
public void SetAffinityToAll(
bool affinityMask
)
public:
void SetAffinityToAll(
bool affinityMask
)
member SetAffinityToAll :
affinityMask:bool -> unit
public function SetAffinityToAll(
affinityMask : boolean
)
Параметры
- affinityMask
Тип: System.Boolean
If true, affinity is set for each CPU in the specified range. If false, the affinity state is removed from each CPU in the specified range.
Примеры
The following example shows how to set affinity to each CPU on an instance of SQL Server.
C#
using System;
using System.Collections.Specialized;
using System.Data;
using Microsoft.SqlServer.Management.Smo;
namespace samples
{
class Program
{
static void Main(string[] args)
{
Server dbServer = new Server("(local)");
dbServer.AffinityInfo.AffinityType = AffinityType.Manual;
dbServer.AffinityInfo.Alter();
dbServer.AffinityInfo.Cpus.SetAffinityToAll(true);
}
}
}
Powershell
$dbServer = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$dbServer.AffinityInfo.AffinityType = [Microsoft.SqlServer.Management.Smo.AffinityType]'Manual'
$dbServer.AffinityInfo.Alter()
$dbServer.AffinityInfo.Cpus.SetAffinityToAll($TRUE)