Adding processors after the fact

Hello all,
When installing additional processor(s) into a Win Server 2003 w/SQL Server 2005 box after it is up and running, does the OS & SQL
Server need to be reinstalled, or will they automatically recognize the new processor(s)?
Thanks for any help anyone can provide,
Conan Kelly
Windows will automatically pick up the new CPUs, and SQL Server will find
whatever the OS has.
Now licensing, that is a different issue. Nothing automatic there. You must
license the new CPUs if necessary -depending upon version.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Conan Kelly" <CTBarbarin@.msn.com> wrote in message
news:cN%bh.403881$QZ1.187976@.bgtnsc04-news.ops.worldnet.att.net...
> Hello all,
> When installing additional processor(s) into a Win Server 2003 w/SQL
> Server 2005 box after it is up and running, does the OS & SQL Server need
> to be reinstalled, or will they automatically recognize the new
> processor(s)?
> --
> Thanks for any help anyone can provide,
> Conan Kelly
>

Adding processors after the fact

Hello all,
When installing additional processor(s) into a Win Server 2003 w/SQL Server 2005 box after it is up and running, does the OS & SQL
Server need to be reinstalled, or will they automatically recognize the new processor(s)?
--
Thanks for any help anyone can provide,
Conan KellyWindows will automatically pick up the new CPUs, and SQL Server will find
whatever the OS has.
Now licensing, that is a different issue. Nothing automatic there. You must
license the new CPUs if necessary -depending upon version.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Conan Kelly" <CTBarbarin@.msn.com> wrote in message
news:cN%bh.403881$QZ1.187976@.bgtnsc04-news.ops.worldnet.att.net...
> Hello all,
> When installing additional processor(s) into a Win Server 2003 w/SQL
> Server 2005 box after it is up and running, does the OS & SQL Server need
> to be reinstalled, or will they automatically recognize the new
> processor(s)?
> --
> Thanks for any help anyone can provide,
> Conan Kelly
>

Adding processors after the fact

Hello all,
When installing additional processor(s) into a Win Server 2003 w/SQL Server
2005 box after it is up and running, does the OS & SQL
Server need to be reinstalled, or will they automatically recognize the new
processor(s)?
Thanks for any help anyone can provide,
Conan KellyWindows will automatically pick up the new CPUs, and SQL Server will find
whatever the OS has.
Now licensing, that is a different issue. Nothing automatic there. You must
license the new CPUs if necessary -depending upon version.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Conan Kelly" <CTBarbarin@.msn.com> wrote in message
news:cN%bh.403881$QZ1.187976@.bgtnsc04-news.ops.worldnet.att.net...
> Hello all,
> When installing additional processor(s) into a Win Server 2003 w/SQL
> Server 2005 box after it is up and running, does the OS & SQL Server need
> to be reinstalled, or will they automatically recognize the new
> processor(s)?
> --
> Thanks for any help anyone can provide,
> Conan Kelly
>

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 More processors not helping improve performances

Hi
I had Enterprise SQL Server installed on my server with 4 processors. Its was great performances in the beginning. Later we got more processes to run.
So, I upgrade hardware to 8 Processors, but surprisingly no improvement in processing time wise. My processes is taking same time as they used to take when I have 4 processors.
E.g. Job-1 was taking 2:15 minutes with 4 processors, it is still taking same time with 8 processors.
Is there anything I am missing while upgrading to processors? I have windows Advanced Server 2000.
appreciate your help.
Thankx
JP
Processor power is only one possible constraint on your system. It is probably that memory, disk, network or design is your current contraint. I would recommend monitoring your database to determine what resource the SQL Server is waiting for.
|||SQL really prefers for each processor to work on a different connection,
instead of having multiple processors work on a single piece of work... You
might check in SQL Enterprise Manager,Right click your
server->Properties->Processors and make sure Use all processors is selected
and Max processors per query is whatever you wish...
However you are likely to get better throughput ( not faster for a single
query tho) by setting max processors per query to 2 or 1. ...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"JP" <anonymous@.discussions.microsoft.com> wrote in message
news:7DBC43F5-09E2-4B37-A91F-BDADC78EBCF9@.microsoft.com...
> Hi
> I had Enterprise SQL Server installed on my server with 4 processors. Its
was great performances in the beginning. Later we got more processes to run.
> So, I upgrade hardware to 8 Processors, but surprisingly no improvement in
processing time wise. My processes is taking same time as they used to take
when I have 4 processors.
> E.g. Job-1 was taking 2:15 minutes with 4 processors, it is still taking
same time with 8 processors.
> Is there anything I am missing while upgrading to processors? I have
windows Advanced Server 2000.
> appreciate your help.
> Thankx
> JP
>
|||I already have Use all processors checked out.. There is no issues of performance.
Just wondering, how come it is taking same time as 4 processors while I have 8 processors.
Or I believe, 4 processors of 2 GHz is maxed out and when I add another 4 processors it is doing better load sharing instead of gaining timewise performances.
-- Wayne Snyder wrote: --
SQL really prefers for each processor to work on a different connection,
instead of having multiple processors work on a single piece of work... You
might check in SQL Enterprise Manager,Right click your
server->Properties->Processors and make sure Use all processors is selected
and Max processors per query is whatever you wish...
However you are likely to get better throughput ( not faster for a single
query tho) by setting max processors per query to 2 or 1. ...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"JP" <anonymous@.discussions.microsoft.com> wrote in message
news:7DBC43F5-09E2-4B37-A91F-BDADC78EBCF9@.microsoft.com...[vbcol=seagreen]
> Hi
was great performances in the beginning. Later we got more processes to run.[vbcol=seagreen]
processing time wise. My processes is taking same time as they used to take
when I have 4 processors.[vbcol=seagreen]
same time with 8 processors.[vbcol=seagreen]
windows Advanced Server 2000.
> Thankx
> JP
>

Adding More processors not helping improve performances

Hi
I had Enterprise SQL Server installed on my server with 4 processors. Its wa
s great performances in the beginning. Later we got more processes to run.
So, I upgrade hardware to 8 Processors, but surprisingly no improvement in p
rocessing time wise. My processes is taking same time as they used to take w
hen I have 4 processors.
E.g. Job-1 was taking 2:15 minutes with 4 processors, it is still taking sam
e time with 8 processors.
Is there anything I am missing while upgrading to processors? I have windows
Advanced Server 2000.
appreciate your help.
Thankx
JPProcessor power is only one possible constraint on your system. It is proba
bly that memory, disk, network or design is your current contraint. I would
recommend monitoring your database to determine what resource the SQL Serve
r is waiting for.|||SQL really prefers for each processor to work on a different connection,
instead of having multiple processors work on a single piece of work... You
might check in SQL Enterprise Manager,Right click your
server->Properties->Processors and make sure Use all processors is selected
and Max processors per query is whatever you wish...
However you are likely to get better throughput ( not faster for a single
query tho) by setting max processors per query to 2 or 1. ...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"JP" <anonymous@.discussions.microsoft.com> wrote in message
news:7DBC43F5-09E2-4B37-A91F-BDADC78EBCF9@.microsoft.com...
> Hi
> I had Enterprise SQL Server installed on my server with 4 processors. Its
was great performances in the beginning. Later we got more processes to run.
> So, I upgrade hardware to 8 Processors, but surprisingly no improvement in
processing time wise. My processes is taking same time as they used to take
when I have 4 processors.
> E.g. Job-1 was taking 2:15 minutes with 4 processors, it is still taking
same time with 8 processors.
> Is there anything I am missing while upgrading to processors? I have
windows Advanced Server 2000.
> appreciate your help.
> Thankx
> JP
>|||I already have Use all processors checked out.. There is no issues of perfor
mance.
Just wondering, how come it is taking same time as 4 processors while I have
8 processors.
Or I believe, 4 processors of 2 GHz is maxed out and when I add another 4 pr
ocessors it is doing better load sharing instead of gaining timewise perform
ances.
-- Wayne Snyder wrote: --
SQL really prefers for each processor to work on a different connection,
instead of having multiple processors work on a single piece of work... You
might check in SQL Enterprise Manager,Right click your
server->Properties->Processors and make sure Use all processors is selected
and Max processors per query is whatever you wish...
However you are likely to get better throughput ( not faster for a single
query tho) by setting max processors per query to 2 or 1. ...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"JP" <anonymous@.discussions.microsoft.com> wrote in message
news:7DBC43F5-09E2-4B37-A91F-BDADC78EBCF9@.microsoft.com...
> Hi
was great performances in the beginning. Later we got more processes to run.[vbcol=seagreen]
processing time wise. My processes is taking same time as they used to take
when I have 4 processors.[vbcol=seagreen]
same time with 8 processors.[vbcol=seagreen]
windows Advanced Server 2000.[vbcol=seagreen]
> Thankx
> JP
>