Windows Server 2003 Enterprise performance problem
Hi good people, Recently, I've been charged with babysitting a HP ProLiant DL360 G3 server with 2 dual core Intel Xeon 3.06 processors and 2GB of RAM. The server runs MySQL and IIS. I have installed Spotlight on MySQL on my PC to monitor the server and it tells me that it has about 1.2GB free RAM. This figure has been consistent even when the server is under heavy use. Now, my problem is that over the last few days, the processor usage has been averaging 90% which is very abnormal. In task manager, the top three processes in order of processor use are System Idle Process, w3wp.exe and mysqld-nt.exe. Even when processor use is above 90%, free RAM never goes below 1GB. What could be causing System Idle Process to use so much processor time yet its memory use is costant at 16k? Another thing, the server has 2GB virtual memory. Is this too much/little considering the total RAM is 2GB? This article<http://support.microsoft.com/kb/555223>suggests that RAM should be 1.5 times the RAM, is this a must? And finally, much as I would really like to, I cant replace the IIS and Windows with Apache and Linux. Thanks. Regards, Peter.
Peter, a suggestion would be to increase physical base memory to a minimum of 4GB. You may also want to check the event viewer for errors and some net stats to determine what's going on. When you disconnect from network, does the server settle down? Have your number of users increased lately? Are the HDDs running constantly? check these things...
Most of the time this is as a result of a query which is not optimized well on mysql u should probably check this. Regrds K Z M ---"It's not your blue blood, your pedigree or your college degree. It's what you do with your life that counts. --- On Tue, May 26, 2009 at 5:05 PM, aki <aki275@googlemail.com> wrote:
Peter, a suggestion would be to increase physical base memory to a minimum of 4GB. You may also want to check the event viewer for errors and some net stats to determine what's going on. When you disconnect from network, does the server settle down? Have your number of users increased lately? Are the HDDs running constantly? check these things...
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
My 2cnts. The 1.5 * physical memory rule has always worked for me performancewise. Based on hard disk sizes today, would not be a loss. Also distributing page file across partitions especially diff controllers. Athar On 5/26/09, Kenneth Muhia <kzmuhia@gmail.com> wrote:
Most of the time this is as a result of a query which is not optimized well on mysql u should probably check this. Regrds K Z M ---"It's not your blue blood, your pedigree or your college degree. It's what you do with your life that counts. ---
On Tue, May 26, 2009 at 5:05 PM, aki <aki275@googlemail.com> wrote:
Peter, a suggestion would be to increase physical base memory to a minimum of 4GB. You may also want to check the event viewer for errors and some net stats to determine what's going on. When you disconnect from network, does the server settle down? Have your number of users increased lately? Are the HDDs running constantly? check these things...
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- Sent from my mobile device
@Aki, Ok, by "physical base memory" you mean virtual memory right? I will check the event log and net stat. The server cannot be disconnected from the network as its mission critical, used 24x7x366. And buying more RAM is not possible at the moment. @Kenneth, There are a couple of nasty queries showing up in the mysql slow query log, i haven't managed to fix them all yet. I will check if they are causing the heavy use. I wish these things could be like the Matrix sometimes, then it'ld be like "Operator, I need to know everything abt windows 03 sys admin, stat!" instead of scrutinizing long boring log files :-) Thanks a bucket! On Tue, May 26, 2009 at 5:05 PM, aki <aki275@googlemail.com> wrote:
Peter, a suggestion would be to increase physical base memory to a minimum of 4GB. You may also want to check the event viewer for errors and some net stats to determine what's going on. When you disconnect from network, does the server settle down? Have your number of users increased lately? Are the HDDs running constantly? check these things...
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
On Tue, May 26, 2009 at 6:17 PM, Peter Karunyu <pkarunyu@gmail.com> wrote:
@Aki, Ok, by "physical base memory" you mean virtual memory right? I will check the event log and net stat. The server cannot be disconnected from the network as its mission critical, used 24x7x366. And buying more RAM is not possible at the moment.
He means "physical" (RAM modules). Virtual Memory is the SWAP/PAGING FILE(S).
@Kenneth, There are a couple of nasty queries showing up in the mysql slow query log, i haven't managed to fix them all yet. I will check if they are causing the heavy use.
You could also use mysqltuner.pl if you can install perl on that Windows. You don't quite have to:) -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ "Clothes make the man. Naked people have little or no influence on society." -- Mark Twain
Hi Peter, 'System Idle Process' is what runs when your cpu has nothing better to do (much like most of us skunks ;) Don't worry about it - in fact, be happy! - sounds like a healthy machine to me. Tony 2009/5/26 Peter Karunyu <pkarunyu@gmail.com>:
What could be causing System Idle Process to use so much processor time yet its memory use is costant at 16k?
-- Tony White
participants (6)
-
aki -
Athar Ahmad Bhatti -
Kenneth Muhia -
Odhiambo ワシントン -
Peter Karunyu -
Tony White