: Problem on application with ASP in IIS 7.5 with Oracle 11g 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.

@Moriarity557

Few things to look at:


Recycle your app pools - set them to recycle based on x number of visits. Its probably a memory leak that is causing this.
Turn on application tracing. This will give you more detailed logs that will make it easier to diagnose your problem.
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.
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.
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).

Vote Up Vote Down