记录一次在生成数据库服务器上出现The timeout period elapsed prior to completion of the operation or the server is not responding.和Exception has been thrown by the target of an invocation的解决办法
2024-09-03 09:21:05
记一次查询超时的解决方案The timeout period elapsed......
https://www.cnblogs.com/wyt007/p/9274613.html
Exception has been thrown by the target of an invocation
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
语句已终止。
问题描述
在数据库中执行查询语句,大约1秒钟查询出来,在C#中用ado进行连接查询,一直等待很久未查出结果,最后抛出查询超时异常。
异常内容如下:
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
解决方案:
exec sp_updatestats
执行结果:
参考文章:
最新文章
- CODESOFT 2015中的二维码该怎样生成
- eclipse与myeclipse工程互转
- hibernate generator class=";"; id详解
- 深入浅出—JAVA(4)
- 一个用js写的接口http调试程序
- The JSR-133 Cookbook for Compiler Writers(an unofficial guide to implementing the new JMM)
- logstash 输出到elasticsearch 自动建立index
- ehcache memcache redis 三大缓存对比
- 微信小程序UI组件、开发框架、实用库...
- 对.NET Core未来发展趋势的浅层判断
- RPC REST 比较
- Confluence 6 home 目录
- git pull 冲突拉取不到新的代码
- Linux系统挂载新磁盘
- 怎么使用JavaScript进行进制转换
- 使用PHPMailer 中的报错解决 ";Connection failed. Error #2: stream_socket_client(): SSL operation failed with code 1. OpenSSL Error messages:";
- 百度地图VUE-REACT
- Spring Batch 批处理框架介绍
- HDU 3435 A new Graph Game(最小费用流:有向环权值最小覆盖)
- NOIP Day1总结