SQL Server Performance Forum – Threads Archive
Lock Timeout?I see Lock Timeout events in Profiler but none of the stored procedures running set the @@lock_timeout variable. Select @@lock_timeout returns -1 which means infinite. Why do I see timeout event when timeout is set to infinite? Please help.
Is this happening against tempdb?
This could be locking on temporary tables built in stored procedures although I can’t say for certain. Are any of your commands making changes to the database/table schema? Cheers
Shaun World Domination Through Superior Software
No tempdb and no schema change. But the stored procedures involve heavy calculations and insert/update. Don’t know if Lock:timeout events are costed by ADO Commandtimeout (30s). THe COM+ transaction global timeout is set to 1000s (for testing purpose).