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]
>

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...
> > 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
> >
> >
>

Adding Disks

I would like to add another volume to my two node sql 2005 cluster. From
what i have been reading i need to shut one of the cluster nodes, add
the drive to the cluster then bring the backup node back on line. Am i
missing anything?
Thanks for the help
Noah Hamilton
Sr Systems Administrator
Carpathia Hosting, Inc
21711 Filigree Court, Suite A
Ashburn, VA 20147
voice: (703) 297-4451
Fax: (703) 997 5577
www.carpathiahost.com
Once you have physically connected the disk (or carved a new LUN and
presented it to the host computers), you must create a clustered resource.
Use the cluster admin tool to create a disk resource and map it to the
physical disk. I usually create a temporary resource group to park it in
while I am setting things up. Test failover to make sure all host nodes can
"see" and use the clustered disk.
You then can move the disk into the SQL resource group. Finally, you must
make the SQL Service dependent on the new disk before SQL will use it for
data or logs. This will require stopping the SQL service while the
dependencies are changed.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Noah" <noah@.carpathiahost.com> wrote in message
news:%23$wrjlp2HHA.4584@.TK2MSFTNGP03.phx.gbl...
>I would like to add another volume to my two node sql 2005 cluster. From
>what i have been reading i need to shut one of the cluster nodes, add the
>drive to the cluster then bring the backup node back on line. Am i missing
>anything?
> Thanks for the help
> Noah Hamilton
> Sr Systems Administrator
> Carpathia Hosting, Inc
> 21711 Filigree Court, Suite A
> Ashburn, VA 20147
> voice: (703) 297-4451
> Fax: (703) 997 5577
> www.carpathiahost.com
>
|||Thanks for the help. I have the new drives up and running now.
Appreciate all the help.
Geoff N. Hiten wrote:
> Once you have physically connected the disk (or carved a new LUN and
> presented it to the host computers), you must create a clustered
> resource. Use the cluster admin tool to create a disk resource and map
> it to the physical disk. I usually create a temporary resource group to
> park it in while I am setting things up. Test failover to make sure all
> host nodes can "see" and use the clustered disk.
> You then can move the disk into the SQL resource group. Finally, you
> must make the SQL Service dependent on the new disk before SQL will use
> it for data or logs. This will require stopping the SQL service while
> the dependencies are changed.
>