数据库优化报错

最近ERP的生产汇报单在进行审核和反审核时总会出现操作超时的的报错信息，不能进行审核&反审核。然后和金蝶的客服沟通后建议优化数据库，但是数据库的优化的时候出现以下报错信息，请各位老师查看是什么原因导致的？以下为主要报错信息：2018-01-25 12:49:31,676 [153] ERROR - BAS - 'TableIndexPercent' EnvironmentDetector Repair is error.
System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): 等待的操作过时。
在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
在 Kingdee.BOS.App.EnvironmentDetect.DataBase.AbstractDataBase.ExecuteDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
在 Kingdee.BOS.App.EnvironmentDetect.DataBase.AbstractDataBase.ExecuteDataSet(DataBaseInfo dataInfo, String sql, DbParameter[] sqlParams)
在 Kingdee.BOS.App.EnvironmentDetect.DataCenterService.ExecuteDataSet(DataBaseInfo dataInfo, String sql, DbParameter[] dbParams)
在 Kingdee.BOS.App.EnvironmentDetect.DataCenterService.ExecuteDataTable(DataBaseInfo dataInfo, String sql, DbParameter[] dbParams)
在 Kingdee.BOS.App.EnvironmentDetect.Detector.SQLServer.SQLServerTableIndexPercentDetector.GetRebulidIndexs(DataBaseInfo dcInfo)
在 Kingdee.BOS.App.EnvironmentDetect.Detector.SQLServer.SQLServerTableIndexPercentDetector.RebuildIndex(DataBaseInfo dcInfo)
在 Kingdee.BOS.App.EnvironmentDetect.Detector.SQLServer.SQLServerTableIndexPercentDetector.Repair()
在 Kingdee.BOS.App.EnvironmentDetect.EnvironmentDetector.Repair(String itemCode)
ClientConnectionId:dece246d-1297-420c-b5c4-c7f8b004675e
Error Number:-2,State:0,Class:11

2018-01-25 12:29:19,032 [6] ERROR - BAS - 'TableIndexPercent' EnvironmentDetector Repair is error.
System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): 等待的操作过时。
在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
在 Kingdee.BOS.App.EnvironmentDetect.DataBase.AbstractDataBase.ExecuteDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
在 Kingdee.BOS.App.EnvironmentDetect.DataBase.AbstractDataBase.ExecuteDataSet(DataBaseInfo dataInfo, String sql, DbParameter[] sqlParams)
在 Kingdee.BOS.App.EnvironmentDetect.DataCenterService.ExecuteDataSet(DataBaseInfo dataInfo, String sql, DbParameter[] dbParams)
在 Kingdee.BOS.App.EnvironmentDetect.DataCenterService.ExecuteDataTable(DataBaseInfo dataInfo, String sql, DbParameter[] dbParams)
在 Kingdee.BOS.App.EnvironmentDetect.Detector.SQLServer.SQLServerTableIndexPercentDetector.GetRebulidIndexs(DataBaseInfo dcInfo)
在 Kingdee.BOS.App.EnvironmentDetect.Detector.SQLServer.SQLServerTableIndexPercentDetector.RebuildIndex(DataBaseInfo dcInfo)
在 Kingdee.BOS.App.EnvironmentDetect.Detector.SQLServer.SQLServerTableIndexPercentDetector.Repair()
在 Kingdee.BOS.App.EnvironmentDetect.EnvironmentDetector.Repair(String itemCode)
ClientConnectionId:db17f9ff-215a-4d12-8a14-b58c29349747
Error Number:-2,State:0,Class:11
2018-01-25 12:34:44,812 [78] INFO - ValidateLoginInfo - UserName:Administrator,UserToken:[64be0139-84a5-43a7-8e1a-319a665f7b24],SessionId:[fe348808-58c0-4dd5-a0c2-744d2370c47a],IpAddress:127.0.0.1,ClientType:Silverlight
2018-01-25 12:35:17,699 [111] ERROR - BAS - 'TableIndexPercent' EnvironmentDetector Repair is error.
System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): 等待的操作过时。
在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
在 Kingdee.BOS.App.EnvironmentDetect.DataBase.AbstractDataBase.ExecuteDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
在 Kingdee.BOS.App.EnvironmentDetect.DataBase.AbstractDataBase.ExecuteDataSet(DataBaseInfo dataInfo, String sql, DbParameter[] sqlParams)
在 Kingdee.BOS.App.EnvironmentDetect.DataCenterService.ExecuteDataSet(DataBaseInfo dataInfo, String sql, DbParameter[] dbParams)
在 Kingdee.BOS.App.EnvironmentDetect.DataCenterService.ExecuteDataTable(DataBaseInfo dataInfo, String sql, DbParameter[] dbParams)
在 Kingdee.BOS.App.EnvironmentDetect.Detector.SQLServer.SQLServerTableIndexPercentDetector.GetRebulidIndexs(DataBaseInfo dcInfo)
在 Kingdee.BOS.App.EnvironmentDetect.Detector.SQLServer.SQLServerTableIndexPercentDetector.RebuildIndex(DataBaseInfo dcInfo)
在 Kingdee.BOS.App.EnvironmentDetect.Detector.SQLServer.SQLServerTableIndexPercentDetector.Repair()
在 Kingdee.BOS.App.EnvironmentDetect.EnvironmentDetector.Repair(String itemCode)
ClientConnectionId:db17f9ff-215a-4d12-8a14-b58c29349747
Error Number:-2,State:0,Class:11
2018-01-25 12:36:53,276 [113] INFO - ValidateLoginInfo - UserName:Administrator,UserToken:[64be0139-84a5-43a7-8e1a-319a665f7b24],SessionId:[329a05ce-a27d-4d26-b98f-d1455f339343],IpAddress:IE-trustless(MAC:browser)>GATE:10.86.127.249,ClientType:Silverlight
2018-01-25 12:42:11,047 [22] ERROR - BAS - 'TableIndexPercent' EnvironmentDetector Repair is error.
System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): 等待的操作过时。
在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
在 Kingdee.BOS.App.EnvironmentDetect.DataBase.AbstractDataBase.ExecuteDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
在 Kingdee.BOS.App.EnvironmentDetect.DataBase.AbstractDataBase.ExecuteDataSet(DataBaseInfo dataInfo, String sql, DbParameter[] sqlParams)
在 Kingdee.BOS.App.EnvironmentDetect.DataCenterService.ExecuteDataSet(DataBaseInfo dataInfo, String sql, DbParameter[] dbParams)
在 Kingdee.BOS.App.EnvironmentDetect.DataCenterService.ExecuteDataTable(DataBaseInfo dataInfo, String sql, DbParameter[] dbParams)
在 Kingdee.BOS.App.EnvironmentDetect.Detector.SQLServer.SQLServerTableIndexPercentDetector.GetRebulidIndexs(DataBaseInfo dcInfo)
在 Kingdee.BOS.App.EnvironmentDetect.Detector.SQLServer.SQLServerTableIndexPercentDetector.RebuildIndex(DataBaseInfo dcInfo)
在 Kingdee.BOS.App.EnvironmentDetect.Detector.SQLServer.SQLServerTableIndexPercentDetector.Repair()
在 Kingdee.BOS.App.EnvironmentDetect.EnvironmentDetector.Repair(String itemCode)
ClientConnectionId:dece246d-1297-420c-b5c4-c7f8b004675e
Error Number:-2,State:0,Class:11