Ryan (ryanofford@hotmail.com) writes:
> I have an application written in Delphi which is very simple and posts
> data back when you save it. However, sometimes this works quickly and
> other times it has a delay of exactly 5 minutes (standard timeout) and
> then rolls back the transaction and re-tries. On this next attempt it
> is successful even though nothing has changed. See lines 61 and 81 in
> the trace below for specifics.
>
> I've gone through my application and it is a standard Borland
> component that posts the data back (and creates the update statement
> that gets passed to SQL). It's about as simple as you can get in terms
> of posting the data back. We can even re-create this with no other
> users in the system.

The most likely reason would be blocking. You can examine this by running
sp_who or sp_who2 when you notice that the UPDATE statement does not return
immediately. Pay attention to the Blk column. If this column is non-zero,
then the spid on this line is blocked by the spid in the Blk column.

You say that this happen even if there are no other users on the system.
This may indicate that the application is blocking itself, when using
multiple connections.

--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp