asp.net – SQL Timeout过期2秒查询

当它从SSMS正确运行时,它应该返回大约30行.

我尝试了几种不同的方法从代码调用过程,但每次都有相同的结果.这刚刚开始发生,昨天它工作正常.

为我们调用该过程的首选方法是使用Linq2Sql,它给出以下错误消息：

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:

Line 16:         public IMultipleResults GetTournamentRatingNonComplaintData([global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "DateTime")] System.Nullable<System.DateTime> startdate,[global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "DateTime")] System.Nullable<System.DateTime> enddate,[global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "Int")] System.Nullable<int> officialSportID,[global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "Char(1)")] System.Nullable<char> gender,[global::System.Data.Linq.Mapping.ParameterAttribute(DbType = "Int")] System.Nullable<int> level)
Line 17:         {
Line 18:             IExecuteResult result = this.ExecuteMethodCall(this,((MethodInfo)(MethodInfo.GetCurrentMethod())),startdate,enddate,officialSportID,gender,level);
Line 19:             return ((IMultipleResults)(result.ReturnValue));
Line 20:         }

有谁知道在SSMS中运行它和通过代码之间的区别是什么？如何解决此问题可以做些什么？