This topic has not yet been rated - Rate this topic

Configuration.Affinity64IOMask Property

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

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

Syntax

C++

JScript

Copy


public ConfigProperty Affinity64IOMask { get; }

Property Value

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

Remarks

The Affinity64IOMask property sets the affinity 64 IO mask configuration option. This property is used to increase input and output performance on 64 bit, 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

Reference

Configuration Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Server Configuration Options

sp_configure (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ