|
Posted by Hugo Kornelis on 10/01/87 11:38
On 27 Jan 2006 07:56:46 -0800, kwdavids wrote:
>Thanks Hugo,
>
>Yes the "fix" does result in intermittent long waits.
>
>While the application was "waiting" I ran sp_lock and sp_who2 and I
>didn't see that anything was waiting for a lock. I also tried to
>connect to the database from Enterprise Manager and got the Error
>message (it times out pretty quick).
Hi kwdavids,
In addition to Erland's suggestions - set up a profiler trace, leave it
running until you have experienced one of those 6-minute delays, then
check for irregularities. (For instance, if no events were captured at
all during that time, the problem is in the connectivity.)
--
Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|