Share via


CpuCollection.SetAffinityToRange 메서드 (Int32, Int32, Boolean)

Sets the affinity mask for the CPUs in the specified range.

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
Public Sub SetAffinityToRange ( _
    startCpuId As Integer, _
    endCpuId As Integer, _
    affinityMask As Boolean _
)
‘사용 방법
Dim instance As CpuCollection 
Dim startCpuId As Integer 
Dim endCpuId As Integer 
Dim affinityMask As Boolean

instance.SetAffinityToRange(startCpuId, _
    endCpuId, affinityMask)
public void SetAffinityToRange(
    int startCpuId,
    int endCpuId,
    bool affinityMask
)
public:
void SetAffinityToRange(
    int startCpuId, 
    int endCpuId, 
    bool affinityMask
)
member SetAffinityToRange : 
        startCpuId:int * 
        endCpuId:int * 
        affinityMask:bool -> unit
public function SetAffinityToRange(
    startCpuId : int, 
    endCpuId : int, 
    affinityMask : boolean
)

매개 변수

  • startCpuId
    유형: System.Int32
    An int from 0 to Count -1 that specifies the beginning of the range of CPUs. If startIndex is not within the valid range, the following exception is returned: Specified argument was out of the range of valid values. Parameter name: startIndex.
  • endCpuId
    유형: System.Int32
    An int that specifies the endIndex of the range. endIndex must be greater than or equal to startIndex and less than [P:Microsoft.SqlServer.Management.Smo.CpuCollection.Count.]If endIndex is not within the valid range, the following exception is returned: Specified argument was out of the range of valid values. Parameter name: endIndexd.If endIndex is less than startIndex, the following exception is returned: The specified range of CPUs is not valid. The value for startIndex must be less than the value for endIndex.
  • affinityMask
    유형: System.Boolean
    If true, affinity is set to each CPU in the specified range. If false, affinity is removed from each CPU in the specified range.

The following example shows how to set the 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.SetAffinityToRange(0, 
                dbServer.AffinityInfo.Cpus.Count-1,
                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.SetAffinityToRange(0, $dbServer.AffinityInfo.Cpus.Count-1, $TRUE)

참고 항목

참조

CpuCollection 클래스

SetAffinityToRange 오버로드

Microsoft.SqlServer.Management.Smo 네임스페이스