我的sql Server 2008安装有问题(安装了10.0.2531.0 – SP1).它作为小型托管环境(大约500个站点)的数据库服务器.
我收到这样的错误:
The client was unable to reuse a session with SPID 62,which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for Failed operations immediately before this error message.
在Windows事件日志中以及运行时:
SELECT * FROM sys.dm_os_performance_counters WHERE object_name = 'sqlServer:General Statistics'
我看到其中一个计数器看起来有点奇怪:
Logins/sec 429 Connection Reset/sec 163459 logouts/sec 399 User Connections 30 Logical Connections 33
任何想法如何检查导致此问题的原因?