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

title	affinity64 Input-Output mask Server Configuration Option | Microsoft Docs
ms.custom
ms.date	03/02/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	article
helpviewer_keywords	processor affinity [SQL Server] binding processors [SQL Server] affinity64 I/O mask option
ms.assetid	d304eae7-5116-40ee-a0fa-0a3c0bc20c01
caps.latest.revision	18
author	BYHAM
ms.author	rickbyh
manager	jhubbard

affinity64 Input-Output mask Server Configuration Option

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

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)