Home Forums SQL Server 2014 Administration - SQL Server 2014 It's emergency situation. Select from locked rows RE: It's emergency situation. Select from locked rows

  • May 25, 2015 at 1:18 am

    #1800336

    sys.dm_tran_locks, identify the session holding the locks, figure out what that session is doing and what the consequences of killing the session will be. If acceptable, kill the session.

    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