Problems with SQL Server 2008 - "The client was unable to reuse a session with SPID 62, which had ..
- by GrZeCh
Hello,
I'm having problems with my SQL Server 2008 installation (10.0.2531.0 - SP1 installed). It works as a database server for small hosting environment (about 500 sites).
I'm getting errors like this:
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.
in Windows event log and when I run this:
SELECT * FROM sys.dm_os_performance_counters WHERE object_name = 'SQLServer:General Statistics'
I see that one of counters looks a little odd:
Logins/sec 429
Connection Reset/sec 163459
Logouts/sec 399
User Connections 30
Logical Connections 33
any ideas how to check what is causing this problem?