Skip to content

Latest commit

 

History

History
27 lines (23 loc) · 1.63 KB

File metadata and controls

27 lines (23 loc) · 1.63 KB
title Server Configuration: affinity64 I/O mask
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 08/26/2025
ms.service sql
ms.subservice configuration
ms.topic how-to
helpviewer_keywords
processor affinity [SQL Server]
binding processors [SQL Server]
affinity64 I/O mask option

Server configuration: affinity64 I/O mask

[!INCLUDE SQL Server]

The affinity64 I/O mask binds [!INCLUDE ssNoVersion] 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 [!INCLUDE ssNoVersion]. This option is only visible on the 64-bit version of [!INCLUDE ssNoVersion].

Related content