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.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  August 31, 2017 at 2:01 am

  #1957595

  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