Devart Forums

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,

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.

Thanks Ludek, excellent reading and has solved my problems.