affinity64 I/O mask Option

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.

This option is only visible on the 64-bit version of Microsoft SQL Server.

See Also

Concepts

affinity I/O mask Option
Setting Server Configuration Options

Other Resources

Monitoring Resource Usage (System Monitor)
sp_configure (Transact-SQL)
RECONFIGURE (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance