Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Lock request time our period exceeded Expand / Collapse
Lock request time our period exceeded
Poll ResultsVotes
Lock request time our period exceeded
0%
0
Member Votes: 0, Anonymous Votes: 0. You don't have permission to vote within this poll.
Author
Message
Posted Monday, April 6, 2009 2:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 7, 2009 2:04 AM
Points: 2, Visits: 7
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.
Post #690813
Posted Monday, April 6, 2009 7:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:42 AM
Points: 14,037, Visits: 28,407
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
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #690989
Posted Tuesday, April 7, 2009 7:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 7, 2009 2:04 AM
Points: 2, Visits: 7
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.
Post #691963
Posted Tuesday, April 7, 2009 7:57 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:42 AM
Points: 14,037, Visits: 28,407
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
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #692025
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse