admin管理员组文章数量:1794759
sqlserver 查询数据库当前正在执行的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
版权声明：本文标题：sqlserver 查询数据库当前正在执行的SQL 内容由林淑君副主任自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.xiehuijuan.com/baike/1686656115a91272.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论