Re: Inconsistent delay posting record

#1

Ryan (ryanofford (AT) hotmail (DOT) com) writes:

Quote:

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 (AT) algonet (DOT) se

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Inconsistent delay posting record

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Re: Inconsistent delay posting record - 08-06-2003 , 05:25 PM