affinity64 mask 伺服器組態選項affinity64 mask Server Configuration Option

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

與 affinity mask 選項類似,affinity64 mask 會將處理器繫結到特定的執行緒。The affinity64 mask binds processors to specific threads, similar to the affinity mask option. 請使用 affinity mask 來繫結前 32 個處理器,然後使用 affinity64 mask 來繫結電腦上剩餘的處理器。Use affinity mask to bind the first 32 processors, and use affinity64 mask to bind the remaining processors on the computer. 這個選項只出現在 64 位元版本的 SQL ServerSQL ServerThis option is only visible on the 64-bit version of SQL ServerSQL Server.


下一版的 Microsoft SQL Server 將不再提供此功能。This feature will be removed in the next version of Microsoft SQL Server. 請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。Avoid using this feature in new development work, and plan to modify applications that currently use this feature. 請改用 ALTER SERVER CONFIGURATION (Transact-SQL)Use ALTER SERVER CONFIGURATION (Transact-SQL) instead.

另請參閱See Also

affinity mask 伺服器組態選項 affinity mask Server Configuration Option
監視資源使用量 (系統監視器) Monitor Resource Usage (System Monitor)
伺服器組態選項 (SQL Server) Server Configuration Options (SQL Server)
sp_configure (Transact-SQL) sp_configure (Transact-SQL)