How to: Configure the Affinity Mask (SQL Server Management Studio)

To carry out multitasking, Microsoft Windows 2000 and Windows Server 2003 sometimes move process threads among different processors. To enable one or more processors, use the affinity mask option.

1. In Object Explorer, right-click a server and select Properties.

2. Click the Processors node.

3. Under Enable Processors, clear the selection of Automatically set processor affinity mask for all processors.

4. In the Processor grid, enable one or more processors to configure the CPU affinity for the Microsoft SQL Server instance.

affinity mask Option

Getting SQL Server 2005 Assistance