查询sqlserver正在运行的sql并关闭

SELECT TOP 100 t.hostname,
                t.loginame,
                percent_complete,
                spid,
                [session_id] ,
                der.[request_id] ,
                [start_time] AS '开始时间' ,
                der.[status] AS '状态' ,
                [command] AS '命令' ,
                dest.[text] AS 'sql语句' ,
                DB_NAME([database_id]) AS '数据库名' ,
                [blocking_session_id] AS '正在阻塞其他会话的会话ID' ,
                [wait_type] AS '等待资源类型' ,
                [wait_time] AS '等待时间' ,
                [wait_resource] AS '等待的资源' ,
                [reads] AS '物理读次数' ,
                [writes] AS '写次数' ,
                [logical_reads] AS '逻辑读次数' ,
                [row_count] AS '返回结果行数',
                t.hostname,
                t.loginame
FROM    sys.[dm_exec_requests] AS der
        CROSS APPLY sys.[dm_exec_sql_text](der.[sql_handle]) AS dest
                left JOIN sys.sysprocesses t ON t.spid=der.session_id
WHERE   [session_id] > 50
       -- AND DB_NAME(der.[database_id]) = 'gposdb'
ORDER BY [cpu_time] DESC;



kill spid;