Webmasters Stack Exchange is a question and answer site for pro webmasters. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have an application developed with .Net on server 2008 R2 and IIS 7.5 which is linked liked to Oracle 11g on another server. Our problem is that we lose the service every two or three or more. The application stops and we have to restart IIS or the server to continue the job (the number of users is less then 50). We have no error message. Do you know anything to do to avoid this situation, something like:

  • A parameter to put on ASP pages
  • A parameter to switch on or off on the server or on the database
share|improve this question

closed as off topic by John Conde Nov 13 '12 at 13:22

Questions on Webmasters Stack Exchange are expected to relate to webmastering within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

Your question belongs on serverfault, but we need more information before it's worth moving over. You say "every two or three or more", or more what? Minutes? Hours? Have you checked the event log? What do you want the parameter to do? Give you an error message? Stop it happening somehow? – paulmorriss Sep 13 '12 at 9:17
Hello,Thank you for your answer, we lose the service every two or three (days) or more – Hichem Sep 17 '12 at 7:17
Can you answer my other questions? – paulmorriss Sep 17 '12 at 8:58

Few things to look at:

  1. Recycle your app pools - set them to recycle based on x number of visits. Its probably a memory leak that is causing this.

  2. Turn on application tracing. This will give you more detailed logs that will make it easier to diagnose your problem.

  3. If your using ODBC to connect to oracle, make sure that you have ODBC connections configured correctly. You can set ODBC max connections to what makes sense for your app. If your ODBC connection runs out of memory then it will crash.

  4. You can write a script to restart IIS every x hours. With IIS we find that we need to restart IIS daily / windows servers weekly. We use multiple IIS nodes behind a HaProxy server so that other iis servers take on the load during these brief restarts.

  5. Make sure you are closing connections to the DB in your app. Read Data, copy to local varaibles, close connections. That goes for both .net and classic asp.

Your best friend here is IIS advanced logging and failed request tracing. It will give you a lot more detail on what is cooking versus IIS built in logs (which do nothing but take up space).

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.