Gets the ConfigProperty object that is used to set the affinity mask configuration option.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Theproperty 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.
Return to top