What does LockTime out event , text data is interpreting ?

Question

What does LockTime out event , text data is interpreting ?

er.mayankshukla

SSCarpal Tunnel

Points: 4190
More actions
August 31, 2017 at 12:37 am

#338904

Hi,
On review the traces, I see multiple lock:Timeout, with text data as 6:2161, 4:1944 with some binarydata :0X710800000600000000000000020006
I have searched a lot on Internet but not getting the clue of what useful information I can derive from here.

Viewing 2 posts - 1 through 1 (of 1 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

It should be the same as the resource description in sys.dm_tran_locks
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-locks-transact-sql

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass