IIS Hangs and web application stops responding, Win 2008 R2, MS SQL 2008 R2 Web Edition

Posted on 2012-08-17
Last Modified: 2014-11-12
My Dear Friends.

We had a web application which was earlier running on Win 2008 R2 with MS SQL 2005 Standard.  Now we have shifted the application to Amazon Web Service with an instance type of Windows 2008 R2 Datacentre with MS SQL 2008 R2 Web Edition.

Sometimes the IIS will stop responding and the application comes on a complete halt.  When we restart the IIS or Recycle the IIS then application starts working again.

Our old server had a memory of 8 GB, but the new one at AWS is 16GB with a better processor too... But still the speed becoms less and after say 24-48 hours the IIS will halt.  after restarting IIS, or Recycling IIS or Restarting Windows it will start working normally again.

The application is developed on and backend is MS SQL

Thanking you in Advance
Dilip Jain
Question by:dilipsjain
    LVL 10

    Expert Comment

    Do you have dedicated application pool for this application?

    Try to change recycling settings for your application pool
    You can specify that IIS recycle an application pool at set intervals (such as every 180 minutes), at a specific time each day, or after the application pool receives a certain number of requests.

    And also check your application event log. IIS generates events in Event Viewer so that you can track the performance of IIS.

    Author Comment

    Thanks damjanholsedl,

    Yes we do have a dedicated application pool for each website

    We set the recycling settings to 180 Mins earlier... The problem is once you do that. every 180 minutes all the existing connections are terminated,  Right now the Recycling setting is kept every night at 02:00 AM. So virtually it is 24 hours.

    The total number of users are around 6000, out of which an average cuncurrent users are around 150-200 users, sometimes it goes upto 600 users on peak days, say month end times.

    Thanks in advance

    Author Comment

    Waiting for a reply friends...
    LVL 20

    Accepted Solution

    Im not sure about how amazon works. But if you can treat it as a normal server you should focus on basic performance measuring.
    PerfMon is your friend.
    But before that, see if your SQL takes all the memory. You should put a max limit on the sql so the memory isnt hogged by the sql.
    When this is remedied (if max memory wasnt set before), you should now gather performance data, disc, memory, network and processor are your targets.
    Analyze the data to get clues about the component yeilding.
    Note SQL could and should be designed with multiple discs and so forth. But this is a quick start!
    Regards Marten

    Author Closing Comment

    Thanks Marten...
    We have changed the SQL memory settings and so for there has not been any problem seen. will come back to you if any additional help required

    thank you once again and have a great day ahead
    Dilip Jain

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
    New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
    This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
    Viewers will learn how the fundamental information of how to create a table.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now