X hits on this document

Word document

SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and ... - page 41 / 76

352 views

0 shares

0 downloads

0 comments

41 / 76

SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability37

affinity I/O mask

The affinity I/O mask option defines the specific processors on which SQL Server I/O threads can execute. The affinity I/O mask option has a default setting of 0, indicating that SQL Server threads are allowed to execute on all processors.

The affinity I/O mask option is defined according to the same conditions as the affinity mask option. It is best to use the default setting of 0.

The sample in Figure 13 shows the affinity mask and affinity I/O mask options set to 0 (the default) in the Server Properties dialog box.

Figure 13

Microsoft Corporation © 2005

Document info
Document views352
Page views352
Page last viewedSat Jan 21 14:23:58 UTC 2017
Pages76
Paragraphs1372
Words23715

Comments