Share via


Configuration.Affinity64Mask Property

Gets the ConfigProperty object that is used to set the affinity 64 mask configuration option.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public ReadOnly Property Affinity64Mask As ConfigProperty 
    Get
'Usage
Dim instance As Configuration 
Dim value As ConfigProperty 

value = instance.Affinity64Mask
public ConfigProperty Affinity64Mask { get; }
public:
property ConfigProperty^ Affinity64Mask {
    ConfigProperty^ get ();
}
member Affinity64Mask : ConfigProperty
function get Affinity64Mask () : ConfigProperty

Property Value

Type: Microsoft.SqlServer.Management.Smo.ConfigProperty
A ConfigProperty object that specifies the settings for the affinity 64 mask configuration option.

Remarks

The Affinity64Mask property sets the affinity 64 mask configuration option. This property is used to increase performance on 64 bit, symmetric multiprocessor systems that are operating under heavy loads. A specific thread can be associated with a specific processor. SQL Server can be allocated specific processors and precluded from specific processors.

Examples

Configuring SQL Server in SMO

See Also

Reference

Configuration Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Server Configuration Options (SQL Server)

sp_configure (Transact-SQL)