Share via

  • Article

Méthode SetAffinityToAll

Sets the affinity mask for all CPUs on an instance of SQL Server.

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
Public Sub SetAffinityToAll ( _
    affinityMask As Boolean _
)
'Utilisation
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
)

Paramètres

  • affinityMask
    Type : 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.

Exemples

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)