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
>