Lock Timeout Exceed messages

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
cjmoore
Posts: 8
Joined: Thu 11 Nov 2004 09:16

Lock Timeout Exceed messages

Post by cjmoore » Mon 04 Oct 2010 11:41

I'm converting an application from Oracle tor MSSQL server (2005) and am experiencing a situation I'm having a problem to understand.

People can be using the application for an hour - 1.5 hours and then Lock Timeout exceed messages start to appear affecting one user and then appearing in others over a 10 minute period.

Even if they close and restart the application the error starts to appear and they have to re-start the database.

I've tried using SQL Profiler, looking at sp_who2 but can't see anything obvious.

Time-outs are occurring on simple selects

Anyone offer any advice would be appreciated.

Regards,

Ludek
Posts: 296
Joined: Thu 12 Oct 2006 09:34

Post by Ludek » Mon 04 Oct 2010 14:43

If you are converting from oracle to ms sql, you should think about "transaction isolation level snapshot". see also

http://www.sqlteam.com/article/transact ... tion-level

or msdn or anything else.

cjmoore
Posts: 8
Joined: Thu 11 Nov 2004 09:16

Post by cjmoore » Tue 05 Oct 2010 00:47

Thanks Ludek, excellent reading and has solved my problems.

Post Reply