Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Prod Web application is down very frequently

Author  Topic 

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2008-03-04 : 13:56:48
We are having this issue since long time, wanted to find the solution for fixing the below issue, as I being database person:
We have a web application developed in c#, this application is down atleast 6 times a day, this was originally done by a consultant and he is no longer working here. In order to fix this issue we end the process of w3wp.exe and then the application will be up. Basically this process w3wp.exe's memory usage is high and when we kill it then the web application will be up and running. Any ideas are greatly appreciated. Thanks!!

jhermiz

3564 Posts

Posted - 2008-03-04 : 14:10:33
We'd need a lot more information, and you'd need to actually check a lot of other things before posting such a vague request.
Check the code and ensure that the connection to the app is being closed in a try / finally / catch block or the using stmnt in C#. Check that you're not storing db connections in global variables or session variables and reusing these over and over.

I cant give you much more information as I need a lot more details as to why this is happening. I can definately see you are frustrated with stopping a process and restarting over 6 times a day..thats definatly a no no in production. Can you check the event logs on the web server or check any log files associated with the application? Usually the event viewer should give you some info as to what is going on...

Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]
Go to Top of Page

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2008-03-04 : 15:03:52
Here is the error from the system event viewer:
Event Type: Warning
Event Source: W3SVC
Event Category: None
Event ID: 1011
Date: 3/4/2008
Time: 12:36:31 PM
User: N/A
Computer: server
Description:
A process serving application pool 'DefaultAppPool' suffered a fatal communication error
with the World Wide Web Publishing Service. The process id was '9664'.
The data field contains the error number.
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2008-03-04 : 15:18:31
It could literally be anything ... a poorly written app that uses too much memory and never releases it, or it is doing an endless loop a few times a day due to poorly written algorithms, or maybe it is trying to access a resource that is unavailable (a server, or a share, or a service, etc) and it just tries over and over without ever giving up or returning an error, who knows what....

If you have the source code, maybe someone can help, but not via a forum -- you'd need to pay someone to spend the time and effort to troubleshoot your app ....

- Jeff
http://weblogs.sqlteam.com/JeffS
Go to Top of Page

jhermiz

3564 Posts

Posted - 2008-03-04 : 21:23:28
Try this link for more help:

http://blogs.msdn.com/david.wang/archive/2005/08/29/HOWTO_Understand_and_Diagnose_an_AppPool_Crash.aspx

Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]
Go to Top of Page
   

- Advertisement -