If you are unlucky enough to be sharing a server with another application, this would be where to prevent SQL using all CPUs.
By default, the affinity settings are 'automatic' i.e. use all processors.
Affinity mask (Processor Affinity) - Controls processors as this can be degrative to performance.
Affinity I/O mask (I/O Affinity) - controls server I/O (you nominate processors to be used for i/o activity)
Never mark the same processors for affinity mask and affinity i/o mask. (see Technet link for details)
Update 10/10/2010 :
Because changing I/O Affinity requires a restart of the SQL Server Service, The radio buttons 'Configured values' and 'Running values' at the bottom of the Affinity screen will show differences in configuration until the restart occurs.
Because changing I/O Affinity requires a restart of the SQL Server Service, The radio buttons 'Configured values' and 'Running values' at the bottom of the Affinity screen will show differences in configuration until the restart occurs.
Technet : Affinity Mask Option
John Daskalakis : SQL Server 2008 and Processors
No comments:
Post a Comment