Lock Timeout Exceed messages

cjmoore · 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 · 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 · Post by **cjmoore** » Tue 05 Oct 2010 00:47

Thanks Ludek, excellent reading and has solved my problems.