SELECT
[session_id],
[request_id],
[cpu_time],
[start_time] AS '开始时间',
[status] AS '状态',
[command] AS '命令',
dest.[text] AS 'sql语句',
[reads] AS '物理读次数',
[writes] AS '写次数',
[logical_reads] AS '逻辑读次数',
[row_count] AS '返回结果行数',
[blocking_session_id] AS '正在阻塞其他会话的会话ID',
DB_NAME([database_id]) AS '数据库名',
[wait_type] AS '等待资源类型',
[wait_time] AS '等待时间',
[wait_resource] AS '等待的资源'
FROM sys.[dm_exec_requests] AS der
CROSS APPLY
sys.[dm_exec_sql_text](der.[sql_handle]) AS dest
WHERE 1=1
ORDER BY [cpu_time] DESC
相关文章
- 安装SQL2008时,在“安装程序支持文件”界面,到正在执行Windows installer报错
- SqlServer正在执行的sql语句
- mssql sqlserver两条求和sql脚本相加的方法分享
- SQL Server查看所有表大小,所占空间
- Windows Server 2008 R2安装Sqlserver 2008的步骤和设置跨网远程访问SQL server
- 如何查看无法在SQL Server 2008 R2中修改的存储过程的定义?
- SQL Server 查看备份集元数据的 4 种方法。
- SQLServer查看和解决死锁的方法
- sql server 查看列备注、类型、字段大小
- 查看SQL Server数据库中各个表和视图的索引所占的空间大小