ASP.NET Sql Timeout

Posted by Petoj on Stack Overflow See other posts from Stack Overflow or by Petoj
Published on 2010-04-13T06:46:43Z Indexed on 2010/04/13 7:32 UTC
Read the original article Hit count: 461

Filed under:
|

Well we have this Asp.Net application that we installed at a customer but now some times we get a SqlException that says "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." now the wired thing is that the exception comes instantly when i press the button, this does not happen every time i press the button so its random.. any idea what i could try to pinpoint the problem?

We are using the EnterpriseLibrary Database block if that matters...

Stack trace: at

System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at

System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at

System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at

System.Data.SqlClient.SqlDataReader.get_MetaData() at

System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at

System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at

System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at

System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at

System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at

System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at

Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior) at

Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command)

© Stack Overflow or respective owner

Related posts about ASP.NET

Related posts about sql-server