Tag:sp_who_lock

  • SQL2005 View Deadlock stored procedure sp_who_lock

    Time:2019-5-3

    The following is my monitoring SQL Server database, whether there are deadlocks and blockages in the performance testing process of the SQL statements, still relatively prepared, left for standby. Call method: Select the corresponding database and exec sp_who_lock USE [master] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE procedure [dbo].[sp_who_lock] as begin declare […]