affinity mask
Type: Advanced option
Default value: 0
When a server is experiencing a heavy load because other applications are running on the same server, it might be desirable to bind thread affinity to a processor.
affinity mask is a bitmapped field that provides SQL Server threads an affinity to processors. This is typically used in conjunction with the affinity I/O mask option just described. Starting from the least-significant digit, each bit that is set to 1 represents the processor on which SQL Server will spawn its threads. Processors are numbered from 0 to 7. You usually leave the eighth processor alone because many system processes—such as domain controllers—default to that processor.
For example, if you want to create the affinity ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
