Have an ERP server on LAN and a IIS in DMZ
Both servers are Dual Core 1.6 GHz, 1 GB memory, no RAID
Bandwith is 10 down / 1 up
Enabled ICMP and ping the wan interface with 39 ms replys
I'm responsible for the servers OS and firewall and network. The IIS is hosting an ASP.net solution. the IIS queries the backend ERP (SQL 2005). I haven't anything to do with the Website and don't have any knowledge about it.
Yesterday we had serious problems since the w3wp.exe process took 100% cpu. There were 60 users accessing the web site. I killed the process but it went to 100% again in few seconds. Restarted the machine but it went to 100% again.
Then I changed the settings for application pools so the w3wp.exe is stopped when it reach 50% cpu. It seemed to help keeping the site stable.
Question 1: I would like to know if this application pool change has any impact for the users accessing the site? Are they experiencing any drop-outs, missing transactions or anything?
Question 2: Why did the w3wp.exe process go to 100%? (Is the hardware to small? or is it bad code in the application? or stupid configured queries against the SQL server?
Question 3: I think 39 ms reply on ping is slow (but not sure). can a slow reply affect the w3wp.exe process?