Posted by Hugo Kornelis on 09/29/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

• Next in forum: Example of binary data type in SQL Server
• Prev in forum: Re: How to find first not null value in column
• Thread view: Re: SQL Server does not exist or access denied

[Reply to this message]