取得现在执行中或被锁的查询

执行下面的SQL：

    SELECT session_id
        ,TEXT
    FROM sys.dm_exec_requests s1
    CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s2
    ORDER BY TEXT

执行下面的SQL：

    SELECT *
    FROM sys.dm_tran_locks
    WHERE resource_database_id = DB_ID('db名')
    -- AND request_mode <> 'S' -- 排除共享锁