affinity64 Input-Output mask (server configuration option)
Applies to: SQL Server
The affinity64 I/O mask binds SQL Server 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 SQL Server. This option is only visible on the 64-bit version of SQL Server.
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)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for