解决 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

dbcc freeproccache