affinity64-mask-server-configuration-option.md

title	affinity64 mask Server Configuration Option | Microsoft Docs
ms.custom
ms.date	03/02/2017
ms.prod	sql
ms.prod_service	high-availability
ms.reviewer
ms.suite	sql
ms.technology	configuration
ms.tgt_pltfrm
ms.topic	conceptual
helpviewer_keywords	processor affinity [SQL Server] affinity64 mask option binding processors [SQL Server]
ms.assetid	75ed08c7-f85c-4e15-9ee1-e7bc545d3293
caps.latest.revision	20
author	MikeRayMSFT
ms.author	mikeray
manager	craigg

affinity64 mask Server Configuration Option

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

The affinity64 mask binds processors to specific threads, similar to the affinity mask option. Use affinity mask to bind the first 32 processors, and use affinity64 mask to bind the remaining processors on the computer. This option is only visible on the 64-bit version of [!INCLUDEssNoVersion].

Note

[!INCLUDEssNoteDepNextAvoid] Use ALTER SERVER CONFIGURATION (Transact-SQL) instead.

See Also

affinity mask Server Configuration Option
Monitor Resource Usage (System Monitor)
Server Configuration Options (SQL Server)
sp_configure (Transact-SQL)
RECONFIGURE (Transact-SQL)