Get locks........

• JMSM

  SSCertifiable

  Points: 5440

  More actions

  November 4, 2009 at 10:46 am

  #217139

  Hello,

  I've got one procedure where i can get all Exclusive locks.

  The output of this script its similar to sp_lock2, this was the script that i used to get any of the output.

  The question is that this script don't gives the start time and the total time that a lock is alive, what process its responsible for it and what processes are been blocked by. I need also to get what aplication that owns the blocking session.

  :blush:

  Can u help m.

  Thanks and regards,

  JMSM 😉

• kaushikrsharma

  SSC Enthusiast

  Points: 142

  More actions

  November 4, 2009 at 2:51 pm

  #1075062

  just run stored procedure

  sp_who2

  you will get everything you needed

  Thanks

  Kaushik