首页新闻找找看学习计划

测试服务器上的SQL SERVER2008数据库读写功能,一秒(1000ms)向数据库写一个数据,有七个程序同时运行,写数据时偶尔出现超时错误,

0
悬赏园豆:20 [待解决问题]

更改数据信息失败!System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ZYTESTDB.SQLHelperDAL.ExcuteNoQuery(String str) in C:\Users\asus\Desktop\服务器测试\testdata\DAL\SQLHelperDAL.vb:line 64

my_is小菜鸟的主页 my_is小菜鸟 | 初学一级 | 园豆:182
提问于:2019-11-12 13:55
< >
分享
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册