SQL Server Performance Forum – Threads Archive
Connection Errorhi when i try to open the database objects of a Databse from object browser in Query Analyzer …it gives me an error as [microsoft][ODBC SQL server Driver][SQL server] Lock request time out period exceeded what should i do? krishna chaitanya.s
Hi,<br />whats your query time out value ?! have you set it !? <br />its their in QA tool and server setting tooo , run sp_configure to see if value is set and increase it according to your requirement.<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br />HTH<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
Hi hemant, the problem is not with all the databases…it is only with the two user databases which i created. i can access the system databases objects from object browser.. krishna chaitanya.s
Hi,<br />then you have to check EP if index is scan ! well at what time you are facing time out ? while inserting / updating or viewing records !<br />also suggest to read :<br /><br /><a href=’http://vyaskn.tripod.com/watch_your_timeouts.htm’ target=’_blank’ title=’http://vyaskn.tripod.com/watch_your_timeouts.htm'<a target="_blank" href=http://vyaskn.tripod.com/watch_your_timeouts.htm>http://vyaskn.tripod.com/watch_your_timeouts.htm</a></a><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
hi hemant SQL – Lock Timeout
Server: Msg 1222, Level 16, State 54, Line 2 Lock request time out period exceeded. LOCK_TIMEOUT
Will timeout the executing command after N milliseconds if it is waiting for locks.
Typically called at the top of in stored procedures, along with set nocount
Is not Pandora#%92s box for solving deadlock issues
Check value via select @@LOCK_TIMEOUT
Over linked servers, test carefully. You may find that the 4-part naming doesn#%92t not work, worst still setting the value before using OPENQUERY may also not work. If you experience this problem, try this syntax:
â€˜set lock_timeout 1000 select col1 from myremotetable#%92) thnx a lot….the above info works krishna chaitanya.s
Refer KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;308518&Product=sql2k for more information also. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.