affinity64-input-output-mask-server-configuration-option.md

title	affinity64 Input-Output mask (server configuration option)
description	Learn about the affinity64 I/O mask option. See when to use it to bind SQL Server disk I/O to a specified subset of CPUs.
author	rwestMSFT
ms.author	randolphwest
ms.date	03/02/2017
ms.service	sql
ms.subservice	configuration
ms.topic	conceptual
helpviewer_keywords	processor affinity [SQL Server] binding processors [SQL Server] affinity64 I/O mask option

affinity64 Input-Output mask (server configuration option)

[!INCLUDE SQL Server]

The affinity64 I/O mask binds [!INCLUDEssNoVersion] disk I/O to a specified subset of CPUs, similar to the affinity I/O mask option. Use affinity I/O mask to bind the first 32 processors, and use affinity64 I/O mask to bind the remaining processors on the computer. If you reconfigure the affinity64 I/O mask, you must restart the instance of [!INCLUDEssNoVersion]. This option is only visible on the 64-bit version of [!INCLUDEssNoVersion].

See Also

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