Aracılığıyla paylaş


Configuration.AffinityMask Property

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

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

Syntax

'Bildirim
Public ReadOnly Property AffinityMask As ConfigProperty
    Get
'Kullanım
Dim instance As Configuration
Dim value As ConfigProperty

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

Property Value

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

Remarks

The AffinityMask property sets the affinity mask configuration option. This property is used to increase performance on symmetric multiprocessor systems that are operating under heavy load. 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

sp_configure (Transact-SQL)