Friday, March 30, 2012

Lock:Timeout + urgent

hi,
I am using SQL server 2000.and trying to resolve a deadlock issue.For
this i am looking at SQL profiler.and while turning the trace on, i
select Lock:Timeout event that needs to be traced.When done so, and
executing other requests, there appears an entry which just mentions
spid number, text data field is empty. I would like to know if after
lock times out,then the processes which are waiting for the lock to be
released, are they re tried again.That is if a process is waiting on a
lock,and lock times out,does SQL server tries to retry the same
process again?and if yes then after how much time interval?and is it
possible to set/change this time interval?

Thanks in advance
donThis is always helpful

http://www.sommarskog.se/sqlutil/aba_lockinfo.html

justwantananswer@.rediffmail.com (Don Nelson) wrote in message news:<dbd41fbb.0410210551.1b7f67e9@.posting.google.com>...
> hi,
> I am using SQL server 2000.and trying to resolve a deadlock issue.For
> this i am looking at SQL profiler.and while turning the trace on, i
> select Lock:Timeout event that needs to be traced.When done so, and
> executing other requests, there appears an entry which just mentions
> spid number, text data field is empty. I would like to know if after
> lock times out,then the processes which are waiting for the lock to be
> released, are they re tried again.That is if a process is waiting on a
> lock,and lock times out,does SQL server tries to retry the same
> process again?and if yes then after how much time interval?and is it
> possible to set/change this time interval?
> Thanks in advance
> don

No comments:

Post a Comment