affinity64 I/O mask 服务器配置选项affinity64 Input-Output mask Server Configuration Option

适用对象:是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

affinity64 I/O maskSQL ServerSQL Server affinity I/O mask 选项类似,用于将 磁盘 I/O 绑定到指定的 CPU 子集。The affinity64 I/O mask binds SQL ServerSQL Server disk I/O to a specified subset of CPUs, similar to the affinity I/O mask option. 使用 affinity I/O mask 只能绑定前 32 个处理器,而使用 affinity64 I/O mask 可以绑定计算机上剩余的处理器。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. 如果重新配置 affinity64 I/O mask,则必须重启 SQL ServerSQL Server实例。If you reconfigure the affinity64 I/O mask, you must restart the instance of SQL ServerSQL Server. 此选项仅出现在 SQL ServerSQL Server的 64 位版本中。This option is only visible on the 64-bit version of SQL ServerSQL Server.

另请参阅See Also

affinity I/O mask 服务器配置选项 affinity Input-Output mask Server Configuration Option
监视资源使用情况(系统监视器) Monitor Resource Usage (System Monitor)
服务器配置选项 (SQL Server) Server Configuration Options (SQL Server)
sp_configure (Transact-SQL) sp_configure (Transact-SQL)