Adding Processors

Hi,
Hope that someone can help me on this.
If I have a 2 nodes clustered SQL Server 2000 (active/passive) and each
server has 2 processors during the installation of SQL Server 2000. Now I
wanted to add 2 more processors onto each server to increase performance.
Will SQL Server 2000 automatically pickup the 2 new processors?
Thanks in advance,
Alex
"Alex" <Yukon@.nospam.nospam> wrote in message
news:euNxLVMcEHA.1144@.TK2MSFTNGP11.phx.gbl...
> If I have a 2 nodes clustered SQL Server 2000 (active/passive) and each
> server has 2 processors during the installation of SQL Server 2000. Now I
> wanted to add 2 more processors onto each server to increase performance.
> Will SQL Server 2000 automatically pickup the 2 new processors?
>
Assuming you are running on Windows 2000 or better? The answer is yes it
will, you could verify that by checking the sql server properties. Processor
tab.
Steve
|||Alex,
Sure, why not? Unless you have set the affinity mask to manage how many
processors SQL Server can use. (In general, don't set the affinity mask.)
Russell Fields
"Alex" <Yukon@.nospam.nospam> wrote in message
news:euNxLVMcEHA.1144@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Hope that someone can help me on this.
> If I have a 2 nodes clustered SQL Server 2000 (active/passive) and each
> server has 2 processors during the installation of SQL Server 2000. Now I
> wanted to add 2 more processors onto each server to increase performance.
> Will SQL Server 2000 automatically pickup the 2 new processors?
>
> Thanks in advance,
> Alex
>
|||Russell and Steve,
Thanks for the information.
Alex
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OBqaovNcEHA.2520@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Alex,
> Sure, why not? Unless you have set the affinity mask to manage how many
> processors SQL Server can use. (In general, don't set the affinity mask.)
> Russell Fields
> "Alex" <Yukon@.nospam.nospam> wrote in message
> news:euNxLVMcEHA.1144@.TK2MSFTNGP11.phx.gbl...
I[vbcol=seagreen]
performance.
>

Adding Processors

Hi,
Hope that someone can help me on this.
If I have a 2 nodes clustered SQL Server 2000 (active/passive) and each
server has 2 processors during the installation of SQL Server 2000. Now I
wanted to add 2 more processors onto each server to increase performance.
Will SQL Server 2000 automatically pickup the 2 new processors?
Thanks in advance,
Alex"Alex" <Yukon@.nospam.nospam> wrote in message
news:euNxLVMcEHA.1144@.TK2MSFTNGP11.phx.gbl...
> If I have a 2 nodes clustered SQL Server 2000 (active/passive) and each
> server has 2 processors during the installation of SQL Server 2000. Now I
> wanted to add 2 more processors onto each server to increase performance.
> Will SQL Server 2000 automatically pickup the 2 new processors?
>
Assuming you are running on Windows 2000 or better? The answer is yes it
will, you could verify that by checking the sql server properties. Processor
tab.
Steve|||Alex,
Sure, why not? Unless you have set the affinity mask to manage how many
processors SQL Server can use. (In general, don't set the affinity mask.)
Russell Fields
"Alex" <Yukon@.nospam.nospam> wrote in message
news:euNxLVMcEHA.1144@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Hope that someone can help me on this.
> If I have a 2 nodes clustered SQL Server 2000 (active/passive) and each
> server has 2 processors during the installation of SQL Server 2000. Now I
> wanted to add 2 more processors onto each server to increase performance.
> Will SQL Server 2000 automatically pickup the 2 new processors?
>
> Thanks in advance,
> Alex
>|||Russell and Steve,
Thanks for the information.
Alex
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OBqaovNcEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Alex,
> Sure, why not? Unless you have set the affinity mask to manage how many
> processors SQL Server can use. (In general, don't set the affinity mask.)
> Russell Fields
> "Alex" <Yukon@.nospam.nospam> wrote in message
> news:euNxLVMcEHA.1144@.TK2MSFTNGP11.phx.gbl...
I[vbcol=seagreen]
performance.[vbcol=seagreen]
>