Hi everyone,
Primary platform is 2005 under 64-bit.
I'm trying to figure out what does 'Processor Affinity' and 'I/O Affinity' means when you're viewing server properties. We've got eight processors.
Thanks for your comments,
Processor Affinity is the list of processors that worker threads are allowed to execute on. The number is a bit mask with one bit aligning to each processor on the system. A value of 0 allows use of all processors.
I/O affinity mask is the list of processors that are allowed to process IO operations, and uses the same bitmask scheme.
In most cases there is no need to change either setting. If you do decide to make changes to either setting ensure that the same processor is not specified in both masks.
|||thankssql
No comments:
Post a Comment