| title | Server Configuration: affinity64 mask | |||
|---|---|---|---|---|
| description | Find out about the affinity64 mask option. See when to use it in SQL Server to bind processors to specific threads. | |||
| author | rwestMSFT | |||
| ms.author | randolphwest | |||
| ms.date | 08/26/2025 | |||
| ms.service | sql | |||
| ms.subservice | configuration | |||
| ms.topic | how-to | |||
| helpviewer_keywords |
|
[!INCLUDE SQL Server]
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 [!INCLUDE ssNoVersion].
Note
[!INCLUDE ssNoteDepFutureAvoid] Use ALTER SERVER CONFIGURATION instead.