Adding a second CPU

Hi all.
I have a 1 cpu server running sql server 2000 sp3a and we would like to add
a second cpu to it and I wonder if it is just a matter of installaing the
second CPU and then start the system and SQL server automaticly start to use
the second cpu or do i have to make any configuration changes for SQL server
to start use the second cpu.
Thanks
Thomas
Once you add the 2nd CPU and re-start the machine SQL Server will
automatically recognise the extra processor.
The only exception would be if you had a an Affinity Mask on (to
restrict to 1 CPU) or were using MAXDOP but these aren't applicable in
your case.
ALI
Thomas_ wrote:
> Hi all.
> I have a 1 cpu server running sql server 2000 sp3a and we would like to add
> a second cpu to it and I wonder if it is just a matter of installaing the
> second CPU and then start the system and SQL server automaticly start to use
> the second cpu or do i have to make any configuration changes for SQL server
> to start use the second cpu.
> Thanks
> Thomas
|||Hi
If the OS sees it on startup, SQL Server will also and will use it. No
changes for you.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Thomas_" wrote:

> Hi all.
> I have a 1 cpu server running sql server 2000 sp3a and we would like to add
> a second cpu to it and I wonder if it is just a matter of installaing the
> second CPU and then start the system and SQL server automaticly start to use
> the second cpu or do i have to make any configuration changes for SQL server
> to start use the second cpu.
> Thanks
> Thomas
|||Thank you very much for your quick reply.
Regards
Thomas
"zashah@.gmail.com" wrote:

> Once you add the 2nd CPU and re-start the machine SQL Server will
> automatically recognise the extra processor.
> The only exception would be if you had a an Affinity Mask on (to
> restrict to 1 CPU) or were using MAXDOP but these aren't applicable in
> your case.
> ALI
>
> Thomas_ wrote:
>
|||Like Mike said, SQL Server will can use the processors detected by the OS.
Depending on your Windows version, additional steps may be needed to install
a multiprocessor HAL:
http://support.microsoft.com/kb/234558
http://support.microsoft.com/default...b;en-us;888729
Hope this helps.
Dan Guzman
SQL Server MVP
"Thomas_" <Thomas_@.discussions.microsoft.com> wrote in message
news:FCED2511-598D-4D4D-9E6D-C4FBE15B2075@.microsoft.com...
> Hi all.
> I have a 1 cpu server running sql server 2000 sp3a and we would like to
> add
> a second cpu to it and I wonder if it is just a matter of installaing the
> second CPU and then start the system and SQL server automaticly start to
> use
> the second cpu or do i have to make any configuration changes for SQL
> server
> to start use the second cpu.
> Thanks
> Thomas

Adding a second CPU

Hi all.
I have a 1 cpu server running sql server 2000 sp3a and we would like to add
a second cpu to it and I wonder if it is just a matter of installaing the
second CPU and then start the system and SQL server automaticly start to use
the second cpu or do i have to make any configuration changes for SQL server
to start use the second cpu.
Thanks
ThomasOnce you add the 2nd CPU and re-start the machine SQL Server will
automatically recognise the extra processor.
The only exception would be if you had a an Affinity Mask on (to
restrict to 1 CPU) or were using MAXDOP but these aren't applicable in
your case.
ALI
Thomas_ wrote:
> Hi all.
> I have a 1 cpu server running sql server 2000 sp3a and we would like to ad
d
> a second cpu to it and I wonder if it is just a matter of installaing the
> second CPU and then start the system and SQL server automaticly start to u
se
> the second cpu or do i have to make any configuration changes for SQL serv
er
> to start use the second cpu.
> Thanks
> Thomas|||Hi
If the OS sees it on startup, SQL Server will also and will use it. No
changes for you.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Thomas_" wrote:

> Hi all.
> I have a 1 cpu server running sql server 2000 sp3a and we would like to ad
d
> a second cpu to it and I wonder if it is just a matter of installaing the
> second CPU and then start the system and SQL server automaticly start to u
se
> the second cpu or do i have to make any configuration changes for SQL serv
er
> to start use the second cpu.
> Thanks
> Thomas|||Thank you very much for your quick reply.
Regards
Thomas
"zashah@.gmail.com" wrote:

> Once you add the 2nd CPU and re-start the machine SQL Server will
> automatically recognise the extra processor.
> The only exception would be if you had a an Affinity Mask on (to
> restrict to 1 CPU) or were using MAXDOP but these aren't applicable in
> your case.
> ALI
>
> Thomas_ wrote:
>|||Like Mike said, SQL Server will can use the processors detected by the OS.
Depending on your Windows version, additional steps may be needed to install
a multiprocessor HAL:
http://support.microsoft.com/kb/234558
http://support.microsoft.com/defaul...kb;en-us;888729
Hope this helps.
Dan Guzman
SQL Server MVP
"Thomas_" <Thomas_@.discussions.microsoft.com> wrote in message
news:FCED2511-598D-4D4D-9E6D-C4FBE15B2075@.microsoft.com...
> Hi all.
> I have a 1 cpu server running sql server 2000 sp3a and we would like to
> add
> a second cpu to it and I wonder if it is just a matter of installaing the
> second CPU and then start the system and SQL server automaticly start to
> use
> the second cpu or do i have to make any configuration changes for SQL
> server
> to start use the second cpu.
> Thanks
> Thomas

Add second dual core processor

If we have a SQL 2005 server with one dual core processor and we want to add
a second dual core processor, can this be accomplished without re-installing
SQL 2005? We are using the per CPU licensing model.
ThanksYou don't have to reinstall SQL Server. for this. You will have to purchase
an extra license for the second CPU.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Tim Kelley" <tkelley@.company.com> wrote in message
news:e0FzwhgxGHA.2432@.TK2MSFTNGP06.phx.gbl...
If we have a SQL 2005 server with one dual core processor and we want to add
a second dual core processor, can this be accomplished without re-installing
SQL 2005? We are using the per CPU licensing model.
Thanks