Méthode CpuCollection.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)

Voir aussi

Référence

CpuCollection Classe

Espace de noms Microsoft.SqlServer.Management.Smo