Lock timeout

Hello all.

I’m interested to see if anybody has any experience/advice for changing the ‘timeout duration (sec)’ property when connected to a SQL 2005 database.

I am looking over some of the performance tweaking options and came across this one.

thanks , Mark

In general it is best to put it to 30 or even to 60 for slow systems.

This because it is possible that a lock takes longer then the standard 10 seconds. At least, the blocked session doesn’t error after 10 seconds. Too many undo’s of partial transactions that timed out can also cost performance.