X hits on this document

Word document

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

262 views

0 shares

0 downloads

0 comments

40 / 76

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

affinity mask

The affinity mask option defines the specific processors on which SQL Server threads can execute. When SQL Server 2005 runs as the dedicated database server or with a SAP application, the affinity mask option uses the default setting of 0.

The 0 setting permits SQL Server threads to execute on all processors. In most situations, the 0 setting provides the best performance because it avoids trapping SQL Server connections on a single processor, while leaving excess capacity on other processors. The 0 setting is used with dedicated database servers and SAP two-tier configurations.

Use the affinity mask option when multiple SQL Server instances and a number of SAP instances run on consolidated hardware. For example:

When multiple instances of SQL Server run on a single server.

To assign each SQL Server instance to particular processes on the server.

The affinity mask option is represented as a binary pattern that is expressed by a decimal number. The affinity mask option settings are shown in the following table.

affinity mask

First processor only

1

Second processor only

2

First and second processor only

3

First four processors

15

First eight processors

255

Microsoft Corporation © 2005

Document info
Document views262
Page views262
Page last viewedTue Dec 06 21:46:58 UTC 2016
Pages76
Paragraphs1372
Words23715

Comments