affinity64 輸入輸出伺服器組態選項affinity64 Input-Output mask Server Configuration Option

適用於: 是SQL Server 否Azure SQL Database 否Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

affinity64 I/O mask 會將 SQL ServerSQL Server 磁碟 I/O 繫結至指定的 CPU 子集 (與 affinity I/O mask 選項很相似)。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. 這個選項只出現在 64 位元版本的 SQL ServerSQL ServerThis option is only visible on the 64-bit version of SQL ServerSQL Server.

另請參閱See Also

affinity Input-Output 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)
RECONFIGURE (Transact-SQL)RECONFIGURE (Transact-SQL)