Multiple processors

OneWorld 733.2 , NT, SQL server 7.0

Currently our enterprise server has one CPU. We are going to add a second
CPU shortly. We have an application written to upload a Z file and create
multiple journal entries and from there we will run the posting into the GL.
My question is will a second processor speed up this process? My guess is
the the posting should improve and that the specially designed program will
only speed up if the developer wrote the code with multitasking in mind.
Have any of you noticed significant performance boosts by adding CPU's?

Thanks,

Crawford Winter
Transamerica Life Canada

We have a similar configuration. We had two and went to four. We did
notice a processing increase, but we had even better results when we raised
our enterprise server from 2 gig to 4 gig. This cut our times in half. We
also tweaked SQL 7.0 performance parameters, but i do not have the docs on
what we did at this time.

We are also looking to increase our RAM from 1 to 2GB. Our experience with
other applications is to have at least one GB per CPU.I have implemented an
SQL standard maintenance plan that reduced the DB size significantly and
probably more efficient. I would be interested if anyone has information on
tweaking SQL.

Thanks,

Crawford Winter

Yes, I think you definetely need to increase you RAM as you increase your
processor. If you wish to get some interesting articles, you may get it from
Microsoft web site themself. It is at:
http://msdn.microsoft.com/sqlserver
You can find quite a lot of information there, newsgroup, technical
articles, sample codes, etc. I'm a MCSD certified as well, and i feel that
the SQL 2000 programming course really helps me a lot in the configuring and
tweaking of SQL. There's so much wonders can be done with SQL 2000, be it as
JDE enterprise server or using it as database storage. Rgds.

Bell
OneWorld Developer
One World B7332,SP 9, AS/400 V4R4M0
Windows NT; Win2000+Citrix Metaframe 1.8a

----- Original Message -----
From: "Crawford Winter" <[email protected]>
To: <[email protected]>
Sent: Wednesday, April 11, 2001 4:31 AM
Subject: RE: Multiple processors


an
on
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=
8940

Bell, did you upgrade from SQL 7.0 to 2000 on your JDE Enterprise server?

Crawford