Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 Microsoft SQL Server.
See Also
Concepts
affinity mask Option
Setting Server Configuration Options
Other Resources
Monitoring Resource Usage (System Monitor)
sp_configure (Transact-SQL)
RECONFIGURE (Transact-SQL)