SQL Server Performance Forum – Threads Archive

Connection Error

hi 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
project engineer-SQLDBA

Hi, whats your query time out value ?! have you set it !? 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. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] HTH Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami

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
project engineer-SQLDBA

Hi, 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 ! also suggest to read : <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> [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami

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:
select *
from openquery([myremoteserver],
â€˜set lock_timeout 1000 select col1 from myremotetable#%92) thnx a lot….the above info works krishna chaitanya.s
project engineer-SQLDBA

Refer KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;308518&Product=sql2k for more information also. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>