Wait Type

• brk5tr

  Ten Centuries

  Points: 1360

  More actions

  February 14, 2013 at 5:50 am

  #274139

  Hi,

  I can see a Wait Type of LCK_M_XX.

  Does this mean the system is trying to aquire this type of Lock, or does it mean I am waiting because some other process has this type of lock on the required object?

  Thanks

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  February 14, 2013 at 5:58 am

  #1587872

  The process that is waiting is trying to acquire that lock.

  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

• brk5tr

  Ten Centuries

  Points: 1360

  More actions

  February 14, 2013 at 6:06 am

  #1587878

  Thats great, thanks for your help.