affinity64 mask 服务器配置选项affinity64 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 mask 将处理器绑定到特定的线程,这与 affinity 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. 此选项仅出现在 SQL ServerSQL Server的 64 位版本中。This 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)