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
>