How do you decide what to set SMP Concurrency to? We have a 2-processor
Alpha, and this concurrency is set to 0. Should I set it to something
else for better performance?
The way I read the manual, 0 means that SQL server will use all of the
cpu's, you only set the value if you would like to limit the number
that is uses.
I have a simple question but one that is causing me a bit of
confusion. I have a 2 processor dedicated SQL Server and would like to
get the maximum CPU utilization possible for SQL Server without
My understanding is that if I set SMP concurrency to "0" then SQL Server
will auto-configure to N-1 which in the case of a dual processor machine
will be 2-1 or 1 dedicated processor.
If I set SMP concurrency to "1" it is essentially the same as "0" in a
dual processor machine.
Finally if I set it to "-1" I will have dedicated SMP support meaning
that all processors will be dedicated to SQL Server. Same as a "2"
setting in a dual processor machine??
My first question is what impact does a "-1" setting have upon the OS?
My second question is what setting would be recommended for the sted
I realize that I did not give db specifics such as size and tranaction
types and frequencies but that is because I am mainly interested in
brief general recomendations that I can apply to more specific
situations as the arise.
Thank you in advance for any replys.
Please remove NO_SPAM from email address to reply.
-------------------- <'((>>>>< <'((>>><