Hi!
I have an IBM x235 Server(DUAL XEON 2.4GHz Processor /18GB RAM) running Microsoft Navision database with SQL2000.
The SQL database is about 18GB, and is growing everyday. With multiple users connected to the SQL (via Navision), performance of the Server has started dropping.
The key bottleneck appears to be the processor speed in this case.. even with dual-processor, SQL tends to ‘use’ all the processor power to ‘service’ just one request at a time. With multiple simultaneous users accessing the database, at any given time, only one user gets the required results while others have to wait for thier turn to get their results.
Is it possible to upgrade the processors? or replace them? Or is it a better idea to go for a new server?
If we think of a new faster server – what would you recommend? I would like to stick to IBM machines, but let me know if you have a better experience with other comparable servers.
Ashish.