Added CPUs

Hi,
If I add more CPUs to an existing computer running SQL Server 2000
Enterprise Edition + SP4, do I need to do anything special to get SQL Server
to recognize the extra CPUs, or does it automatically detect them? What
about Windows Server 2003 Enterprise Edition + SP2? I'd be going from 2
CPUs to 4 CPUs.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
It will detect and use automatically. If you want to check read about sp_configure and "affinity
mask". This setting specifies which CPUs SQL Server can use. By default all.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Daniel Jameson" <no_djameson_spam@.childrensoncologygroup.org> wrote in message
news:uEvg1JElIHA.4076@.TK2MSFTNGP05.phx.gbl...
> Hi,
> If I add more CPUs to an existing computer running SQL Server 2000 Enterprise Edition + SP4, do I
> need to do anything special to get SQL Server to recognize the extra CPUs, or does it
> automatically detect them? What about Windows Server 2003 Enterprise Edition + SP2? I'd be going
> from 2 CPUs to 4 CPUs.
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>
|||Cool. Thanks for the quick answer.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23$sjjgElIHA.1744@.TK2MSFTNGP05.phx.gbl...
> It will detect and use automatically. If you want to check read about
> sp_configure and "affinity mask". This setting specifies which CPUs SQL
> Server can use. By default all.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Daniel Jameson" <no_djameson_spam@.childrensoncologygroup.org> wrote in
> message news:uEvg1JElIHA.4076@.TK2MSFTNGP05.phx.gbl...
>
sql