Lock request time our period exceeded

Question

Lock request time our period exceeded

radha.swaminathan

SSC Rookie

Points: 34
More actions
April 6, 2009 at 2:55 am

#203212

When i try to run a update query from my vc++ application, getting the error like 'Lock request time our period exceeded' please any one suggest how to handle this error.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398679 More actions · Answer 1

Something is holding a lock on your system. It could be a long running process or an uncommitted or unrolledback transaction. Try looking at sys.dm_os_waiting_tasks or sys.dm_tran_locks to see what's there. Most of the time, the timeout is set at the connection level. I think the default is -1, which is wait forever. You could try modifying your connection string to set the value higher.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

radha.swaminathan SSC Rookie Points: 34 More actions · Answer 2

Hi,

Thanks for the Quick reply. Is there any alternative for SET LOCK TIME OUT 1. The vc++ application should not throw the 'Lock time out period exceeded' Plese update me.

Thanks.

Grant Fritchey SSC Guru Points: 398679 More actions · Answer 3

I'm not sure. It's a connection setting and if your connection is setting something other than -1, then it may need to be adjusted.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning