常用功能性SQL 查询当前执行sql，查询存储过程

以下语句为sql server数据库

--------------------------------------查询数据库当前正在执行的SQL--------------------------------------

SELECT TOP 100 t.hostname,
                t.loginame,
                percent_complete,
        [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

--------------------------------------查询存储过程--------------------------------------

SELECT DISTINCT obj.Name 存储过程名,xtype
FROM syscomments sc
INNER JOIN sysobjects obj ON sc.Id = obj.ID
WHERE sc.TEXT LIKE '%PL_EndCon%'