SQL SERVER错误SPID 58,The failure ID is 29.

[狂奔吧蜗牛]

各位“牛哥”:
我们的项目中遇到了一个可能是由SQL出错引起的异常，具体异常表现是：
系统对稍大点的数据处理时间很慢，这种现象是最近几天突然出现的，对数据处理速度最近几天骤然下降，查了我们的程序没有异常，在查看系统日志的时候发现有如下SQL错误，请各位大神不吝赐教下，指导下小弟,不生感激
Log Name: Application
Source: MSSQLSERVER
Date: 4/19/2013 5:06:36 PM
Event ID: 18056
Task Category: Server
Level: Error
Keywords: Classic
User: N/A
Computer: XXXXXXXXXXXXXX
Description:
The client was unable to reuse a session with SPID 58, 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.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQLSERVER" />
<EventID Qualifiers="49152">18056</EventID>
<Level>2</Level>
<Task>2</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2013-04-19T09:06:36.000000000Z" />
<EventRecordID>8015</EventRecordID>
<Channel>Application</Channel>
<Computer>THCN-MH-POS1.THCN.COM</Computer>
<Security />
</System>
<EventData>
<Data>58</Data>
<Data>29</Data>
<Binary>88460000140000000D0000005400480043004E002D004D0048002D0050004F0053003100000000000000</Binary>
</EventData>
</Event>

[最爱午夜]

1、你这个太片面了，光靠系统日志无法锁定问题，需要监视数据库，你在服务器运行缓慢的情况下监视一个小时，看看监视的日志，用系统性能监视器和sql profiler

[發糞塗牆]

试试