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)