• 项目

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)