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 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|||This is a multi-part message in MIME format.
--=_NextPart_000_003C_01C464C9.3A5E7710
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
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 only '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-356D-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 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 just wanted to see if i am missing something..
Thanks
--=_NextPart_000_003C_01C464C9.3A5E7710
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
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 only 'know' about 2, since =you've set affinity mask to those two processors.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine
"chinn"
--=_NextPart_000_003C_01C464C9.3A5E7710--|||Licensing doesn't work that way. You will have to go to the BIOS and
completely disable the CPUs or remove them from the hardware. From the SQL
Server Licensing FAQ:
--snip
Q. Do I have to license all of the processors in a server?
A. You only have to acquire licenses for processors that are
accessible to any copy of the operating system upon which SQL Server 2000 is
installed.
--snip
Here is the complete FAQ:
http://www.microsoft.com/sql/howtobuy/faq.asp
Here is the How To Buy page which has all the licensing links:
http://www.microsoft.com/sql/howtobuy/default.asp
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"chinn" <chinn@.discussions.microsoft.com> wrote in message
news:65770508-2603-4A1D-AFC7-B8F710931446@.microsoft.com...
> 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...
> > >
> > > 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
> >
> >
> >
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end|||> 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.)
No comments:
Post a Comment