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

Posted on 2012-08-17
Medium Priority
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 ASP.net and backend is MS SQL

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

Expert Comment

ID: 38304110
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

ID: 38304138
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

ID: 38311098
Waiting for a reply friends...
LVL 20

Accepted Solution

Marten Rune earned 2000 total points
ID: 38312221
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

ID: 38319052
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

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
I’m willing to make a bet that your organization stores sensitive data in your Windows File Servers; files and folders that you really don’t want making it into the wrong hands.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

601 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