sql-server - 处理器亲和性和 I/O 亲和性之间的区别

Question

我正在准备认证，并试图了解处理器关联性和 I/O 关联性之间的区别。如果有人能用简单的语言向我解释这一点，我将不胜感激。尝试在 MS 链接上了解它，但感到困惑。非常感谢

Answer 1

我不是 DBA，但据我了解，SQL Server 在多线程上运行(生成多个线程来服务请求)，是一个多线程应用程序。

您可以指定/映射特定线程以在特定 CPU 上工作(因为高端服务器计算机将在 16 个或更多 CPU 上运行)。这称为处理器亲和性。

而关联性 I/O 掩码 或 I/O 关联性 选项将 SQL Server 磁盘 I/O 绑定(bind)到指定的 CPU 子集

来自MSDN Documentation ，具体摘录

To carry out multitasking, Microsoft Windows 2000 and Windows Server 2003 sometimes move process threads among different processors. Although efficient from an operating system point of view, this activity can reduce Microsoft SQL Server performance under heavy system loads, as each processor cache is repeatedly reloaded with data. Assigning processors to specific threads can improve performance under these conditions by eliminating processor reloads; such an association between a thread and a processor is called processor affinity.

SQL Server supports processor affinity by means of two affinity mask options: affinity mask (also known as CPU affinity mask) and affinity I/O mask