I have a ongoing issue with my website, where it appears the
W3wp.exe crashes and in turn anyone attempting to connect to the site will
receive a SQL server timeout error.
The error is this...
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not responding.
What actually happens is when this occurs, the CPU usage on
the server maxes out to 100% and stays there. During this time if I try and connect
to the homepage the site will appear to be loading and then timeout. This is
also the case when i try and connect to the database through management studio.
I get the above SQL timeout error from ELMAH when it emails me exceptions. When
I do a iisreset I can once again connect to SQL server and the CPU usage drops immediately.
Now I have already posted a few questions oh here about the
issue in regards to the SQL time out exception. So ill list what I have done
and what im using...
- Im using Linq to SQL.
- IIS 7.5 & SQL Server 2008 R2.
- Disposing of all objects.
- The call to the Linq to SQL dataContext is
always wrapped in a USING Keyword.
These timeout errors
View Complete Post