SqlException (0x80131904): Timeout Expired.

I am running Windows 2003 Server, ASP.NET 2.0, IIS, SQL 2005, and VS 2005.  This is a Dell dual 3.0GHz with 3GB RAM.

Off and on we get an error like below on simple queries that should take less than a second to run.  Then if we wait a while and try again, it will run fast.  The error states a timeout problem.  As we look at RAM and CPU usuage, we are fine.  However, SQL Profiler does show that the duration for some of these very simple queries take forever.  One example query selects a row from a table with only 19 rows.



Server Error in '/' Application.


Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.

Source Error:





Line 39:
Line 40: MyConnUpdate.Open()
Line 41: cmdUpdate.ExecuteNonQuery()
Line 42: MyConnUpdate.Close()
Line 43: End Sub
Source File: d:wwwrootweb
ewsblogviewDetails.aspx.vb    Line: 41

Stack Trace:





[SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857466
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735078
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
viewDetails.IncrementViewCount(Int32 newsID) in d:wwwrootweb
ewsblogviewDetails.aspx.vb:41
viewDetails.Page_Load(Object sender, EventArgs e) in d:wwwrootweb
ewsblogviewDetails.aspx.vb:8
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061





Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

 

Any help would be greatly appreciated!

Thanks,

Nate Dogg