We help IT Professionals succeed at work.

Adding a second CPU?

jamessa
jamessa asked
on
Medium Priority
501 Views
Last Modified: 2012-08-13
I have a Dell PE 2600 with a single XEON 2.8 ghz Model 2 stepping 7 400 mhz fsb and 2 gb of ram.

I am running a payroll database on this machine using Pervasive SQL V8.  The processor really spikes pretty hard, somtimes at 60-90%.  I think this might be causeing a bit of a slow down.  When it spikes it is ntdbsmgr.exe and it only spikes every 10 - 20 seconds.

I am thinking about putting another processor in this machine to help out.

1. Could someone give me some pointers on this?  
2. Would Pervasive SQL V8 handle multi procs?
3. Would it even be worth it or should I just budget a new server for next year?  I am basing this off of the 400 mhz bus and limited chip cache (512)

Thanks

Comment
Watch Question

Author

Commented:
BTW I have got a quote from dell for $902 to do this.

Here is what they included
Processor,80532,2.8GHz,512,SKF400C1 (0W761) 1 $750.00  
Heatsink,Plastic Grid Array, 2.5X3.5X4.21 (5M125) 1 $19.95    
Assembly,Clip,Heatsink Dimension,8100 (83MGJ) 2 $4.95    
Assemlby,Carrier,Mounting, Plastic,Fan,P2600 (6K808) 1 $19.95  
Card,Voltage Regulator Module,12V,9.1 (8R158) 1 $39.95  

Is this all I would need?
Commented:
A periodic spike to 60 or 90% in my opinion doesn't justify that expense. Have you checked that all the recommended database system config file settings are correct or can they be increased? For example, threads or semaphors. We have database servers touching 100% and staying there during certain peak times but the rest of the time they run about 35%.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
CERTIFIED EXPERT
Top Expert 2007
Commented:
I would also check the tuning options before spending $1000 on a 2nd CPU,, unless you plan on needing it for othe reasons ( additional load etc ).

I hope this helps !

Author

Commented:
Ok I am under configuration - Server - Performance tuning.

Can someone help me out from here? I dont want to make anything slower.

Commented:
I would check the database documentation for tuning parameters.
You are wasting time and money trying to fine tune this Dell for this application.   You can buy a CLONE 3.6 GHZ AMD system for less than the second CPU in this computer (dell is ridiculously expensive for this stuff) -- and you can use that as a server, and relegate the Dell to desktop apps.
CERTIFIED EXPERT
Top Expert 2007

Commented:
This is more a software question than hardware.

As long as you hae enough RAm, then tuning is probably all that is required.

I would post a link in the appropriate TA.

I hope this helps !
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.