Assiging CPU 's to Sql Server..

Hello,
We have a 4 way machine(Quad CPU) but we want to make sql server use two cpu
's for this
to achieve should i go to processor tab under server properties check two C
PU's right for example
we have 0,1,2,3 should i check 2,3 and uncheck 0 and 1 and also under parlle
lisim should i change the
that option to use 2 Processors instead of use all avaliable processors.
I just wanted to see if i am missing something..
Thanks"chinn" <chinn@.discussions.microsoft.com> wrote in message
news:CBD4DD00-356D-498C-957D-ED17114AD090@.microsoft.com...
> We have a 4 way machine(Quad CPU) but we want to make sql server use two
cpu's for this
> to achieve should i go to processor tab under server properties check two
CPU's right for example
> we have 0,1,2,3 should i check 2,3 and uncheck 0 and 1 and also under
parllelisim should i change the
> that option to use 2 Processors instead of use all avaliable processors.
>
I'm curious to know why you need to make this change? Usually you are far
better off letting the OS manage the CPU's.
Steve|||It's the sp_configure "affinity mask" option.
Please read BOL for full details.
Al
"chinn" wrote:

> Hello,
> We have a 4 way machine(Quad CPU) but we want to make sql server use two c
pu's for this
> to achieve should i go to processor tab under server properties check two
CPU's right for example
> we have 0,1,2,3 should i check 2,3 and uncheck 0 and 1 and also under parl
lelisim should i change the
> that option to use 2 Processors instead of use all avaliable processors.
>
> I just wanted to see if i am missing something..
> Thanks|||Steve,
We just want to license two cpu's for sql server and latter on add if needed
.
Thanks,
"Steve Thompson" wrote:

> "chinn" <chinn@.discussions.microsoft.com> wrote in message
> news:CBD4DD00-356D-498C-957D-ED17114AD090@.microsoft.com...
> cpu's for this
> CPU's right for example
> parllelisim should i change the
> I'm curious to know why you need to make this change? Usually you are far
> better off letting the OS manage the CPU's.
> Steve
>
>|||You don't need to change degree of parallelism. A value of 0 allows SQL to
use all available processors that it 'knows' about. In your case it will on
ly 'know' about 2, since you've set affinity mask to those two processors.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine
"chinn" <chinn@.discussions.microsoft.com> wrote in message news:CBD4DD00-356
D-498C-957D-ED17114AD090@.microsoft.com...
Hello,
We have a 4 way machine(Quad CPU) but we want to make sql server use two cpu
's for this
to achieve should i go to processor tab under server properties check two C
PU's right for example
we have 0,1,2,3 should i check 2,3 and uncheck 0 and 1 and also under parlle
lisim should i change the
that option to use 2 Processors instead of use all avaliable processors.
I just wanted to see if i am missing something..
Thanks|||> We just want to license two cpu's for sql server and latter on add if
needed..
Sorry, you'll need to physically remove the CPUs to do this.
I've postulated this before, but I guess that the reason is that when
licensing compliance officers stop by, it's pretty easy to change a "use n
processors" flag in the GUI, but it's a little more tedious to frantically
remove physical CPUs.
http://www.aspfaq.com/
(Reverse address to reply.)