Problem with IIS and w3wp process PLEASE HELP!

Portal Home > Knowledgebase > Articles Database > Problem with IIS and w3wp process PLEASE HELP!

Posted by Violeta, 07-09-2008, 11:05 PM
I am stuck! Please help It might be difficult to explain the problem via email, but I will try. I have to come to the campus anyway and I do not mind stopping by at all. I have a Win 2003 Enterprise server running with the only purpose of a membership web site that uses SQL server 2000 database. I had the site for over 5 years, but the problem started about 6 months ago. At random times (at least I have not found yet any certain time or event when it happens), the Web site Times-out and so the SQL server. Everything takes about 1-3 minutes and then everything is back to normal. I receive all timeout errors via email and I can tell when exactly happens. It may not happen some days at all, some days it may happen 7-8 times. I have ran Performance Monitor and SQL Profiler during these problem times and I have log files that the results below. I am attaching a few graphics too. This does not particularly happen when there are a lot of users on the site. It might happen in the middle of the night when there is hardly anyone. I am puzzled by the fact that suddenly Web Service\Current Anonymous Users\_Total suddenly increases 3-4 times (somtimes even more) and at the same time Process\%Processor time\SQL Server decreases to almost 0%. Almost all pages are using the SQL server, so more connections would mean more work for the SQL server... Now, I found recently that sometime (not always) when I the problem appears, the application pool, w3wp takes a lot of Processor time. In this case I keep receiving errors until I end the application pool process from Task Manager; then a new application pool process starts up and everything is back to normal. That made me think that there is something that affects the application pool and beacuse of that, the requests to the SQL server are not sent, so the pages timeout; however, I am not sure how to figure out what exactly affects the application pool. I have a couple of dump files where that report the application pool crash. I tried to open them with Debugging tools for Windows, but it seems I get an error reading it. I am not familiar with reading dump files, so I might be doing something wrong. I am attaching the results in a text file. That is where I am now. If you have any ideas and you can point me where to look for a solution, please let me know. I really appreciate you taking the time to read this email and help me out! I Thank you! Violeta Please email me at vclaxton@yahoo.com I will owe you a big one! COLLECTED DATA DURRING TIMEOUT (this is just one certain time, but similar things happen every time when the problem appears) ------------------------------------------ Active Server Pages\Requests Executing The number of ASP requests currently executing (for example, the number of active worker threads). Increase from 3 to 26 Active Server Pages\Requests Queued The number of queued ASP requests that are waiting to be processed. Increase from 10 to 26 Active Server Pages\Sessions Current No Change - Average 289 Network Adapter\Bites Sent Drops down from 254428 to 7304 Processor\%Processor time\Total Drops down from 50% to 20% Process\%Processor time\SQL Server Drops down from 90% to 0.2% SQL Server\General Statistic\User Connections Increase from 25 to 65 SQL Server\SQL Statistic\Compilations/sec Drops down 15 to 0 Web Service\Current Connections\_Total No Change - Average 74 Web Service\Current Anonymous Users\_Total Increase from 17 to 54
Posted by PremiumHost, 07-09-2008, 11:47 PM
How much ram do you have on the server? Application pool is the w3wp process to run your website. You can configure application pool to recycle every X hours or when it uses more than X MB of Ram
Posted by Violeta, 07-09-2008, 11:51 PM
There is 4gigs of ram, however that is not the problem. It is configured properly. I belive there is some application that affacts the application pool. I am looking for suggestion to find out, what affects the application pool