October 30, 2006 at 4:31 pm
When I execute sp_configure on each of my SQL boxes the affinity mask minimum is listed as -2147483648 and the maximum is 2147483647 are those the defaults that are set out of the box and I have between 4 and 8 processors on each of the servers is there a benifit to changing the minimum to 0 or should I leave it alone?
November 1, 2006 at 10:07 am
The short and simple answer is to leave it alone. SQL Server will use all CPUs on the server for processing.
The long answer is that the affinity mask controls how many CPUs that a SQL Server instance may use. This is useful on servers with multiple instances and lots of CPUs - more than 16 I'd say. Otherwise each instance of SQL Server on server will try to use all of the CPUs.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
November 1, 2006 at 11:22 am
Thanks very much. I appreciate you confirming what I thought.
November 16, 2006 at 4:51 pm
yes... good post however;
say you have the usual multi-threaded cpu's in an 8 - 12 cpu environment...
would it be worth adjusting?
i too have the automatic setting; and i'm not getting the 'power' or speed
as i should regardless of query tweaks. just wondering if any one has any
performance increase by setting this to some thing other than the usual
automatic setting.
_________________________
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply