如何调查ASP.net应用程序上的SQL Server超时错误？

当我们结束sql进程时,错误只会重新发生.在结束时它开始工作正常一段时间然后再次开始发生.

这种情况仅在过去的几天发生,之前它工作正常.请注意,其代码中未进行任何重大更新.

我们一无所知,可能是什么问题以及如何调查和修复它？它是连接池相关的问题还是什么？

这是堆栈跟踪：

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
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.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception,Boolean breakConnection) +296
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +415
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,SqlCommand cmdHandler,SqlDataReader dataStream,BulkCopySimpleResultSet bulkCopyHandler,TdsParserStateObject stateObj) +2657
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +88
System.Data.SqlClient.SqlDataReader.get_MetaData() +114
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,RunBehavior runBehavior,String resetOptionsString) +505
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior,Boolean returnStream,Boolean async) +1896
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,String method,DbAsyncResult result) +480
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,String method) +28
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior,String method) +854
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +22
System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator,EntityConnection connection,Dictionary2 identifierValues,List1 generatedValues) +269
System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager,IEntityAdapter adapter) +528