General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Suggestions for Upgrade or new Server..
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.