The server often ignores MS SQL insert/update/delete requests from our hosted data driven .NET 4.0 app. Using SQL Server 2008 R2. At other times response takes several seconds for a small DB. Maybe related, we have an ASP.NET Session object in the website which very often quickly expires. What can we do to fix this? Thanks.
You can try using SQL Server Session State as described in this Knowledge Base article: http://support.Winhost.com/KB/a626/how-to-enable-aspnet-sql-server-session-on-your-web.aspx
We do not use any ASP.NET session objects. We also noticed that if the user take 30 seconds or so to fill a form to add a record to our DB the request is ignored by the server. How often is the Application pool Recycled in the server?
Here are the conditions for an application pool recycle: 1) CPU usage of 75% or greater within a 5 minute period. 2) Exceeding the memory limit for your hosting account. 3) Exceeding the Idle Timeout of 20 minutes.
How can we check if our site reaches the threshold condition for an app pool recycle? And are there any other reasons the IIS server would ignore a request when a user takes more than 30 seconds to fill a form? Our DB is small, our site is small.
The Event Viewer logs where recycing events are being written is not available for viewing on our shared production servers. The system administrators have to search those logs manually. Please open a support ticket through our support portal at support.Winhost.com. In your ticket, provide us with the instructions we can follow to re-create the issue on our end. Once we reproduce the problem, we will check the logs to see if your application pool is being recycled.
