SQLserver 用户进程堵塞解决方案；

USE [master]  
GO


/****** Object:  StoredProcedure [dbo].[kill_bak2]    Script Date: 08/07/2015 15:45:42 ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO




CREATE PROCEDURE [dbo].[kill_bak2] 
 -- @minutesSinceLastBatch int
AS


DECLARE cspids CURSOR FAST_FORWARD FOR  -----------------------------------------设定游标
    SELECT
r.session_id  ---------------------------------------------------------------spid
, TotalElapsedTime_ms = r.total_elapsed_time  ---------------------------------超时时间
, r.[status] ------------------------------------------------------------------状态
, r.command  -----------------------------------------------