Server very slow. CPU Usage reach 100% for sqlservr.exe
Posted on 2005-03-07
Originally we have a Dell PowerEdge 2600/1.8Ghz model with 1024K (512K x 2) RAM. It has 1 Xeon Processor 2400MHz/512K
Recently, we added another 1024K(512K x 2) of RAM to the server to increase it's performance.
But the server speed does not seem to improve. In fact users who access the server (they access through the browser. They use this application to retrieve data from the sql database in the server) complained that the server has slowed down. Before the addition of the RAM, when the users run the heaviest task which is the a Search task that retrieve data from mant different tables, the server will just go slower, but after adding the RAM, they complained that the server sometimes got so slow that they thought the server has hanged up when the run that search function. When 1 user is running the search function, other users has a hard time using that application because simple task become very slow.
I have checked the task manager and it seems that CPU usage always reach 100% when user is using the Search function (but sometime server will also get slow when this function is not use). The process cause this is sqlservr.exe.
Furthermore, java.exe may also go to 50% usage when Tomcat is starting but it will go back to 0% after that. As for the Memory usage, only like 20% of memory is shown being used when I try the Search function.
I try removing the new RAM to see if there will be any difference. But the outcome is still the same. The CPU usage still reach up to 100%.
Lastly, there are some other application who when tried in a normal PC (windows XP with only 512K RAM) works fine, but also slowed down when it was transfered to the server.
I have also updated the windows 2000 and server BIOS to the latest version.
Anyone have any suggestion only solving the problem?
My collegue has also mentioned that the performance of the sql database also depends on the type of harddisk. Can anyone confirm this?