Export (0) Print
Expand All
Expand Minimize
0 out of 2 rated this helpful - Rate this topic

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.

To configure 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.