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.
| 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] |
 |
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2008-03-04 : 15:03:52
|
| Here is the error from the system event viewer:Event Type: WarningEvent Source: W3SVCEvent Category: NoneEvent ID: 1011Date: 3/4/2008Time: 12:36:31 PMUser: N/AComputer: serverDescription: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. |
|
|
|
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 ....- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
jhermiz
3564 Posts |
|
|
|
|
|
|
|
Prod Web application is down very frequently