SELECT
a.spid ,
a.blocked ,
lastwaittype = RTRIM( a.lastwaittype ),
waitresource = RTRIM( a.waitresource ),
a.waittime ,
a.[dbid] ,
a.cpu ,
a.physical_io ,
a.login_time ,
a.last_batch ,
a.ecid ,
a.open_tran ,
[status] = RTRIM( a.[status] ),
hostname = RTRIM( a.hostname ),
[program_name] = RTRIM( a.[program_name] ),
hostprocess = RTRIM( a.hostprocess ),
cmd = RTRIM( a.cmd ),
loginame = RTRIM( a.loginame ),
b.[text]
FROM sys.sysprocesses a with(nolock)
OUTER APPLY sys.dm_exec_sql_text( a.sql_handle) b
LEFT JOIN sys. dm_exec_requests c with(nolock)
ON a .spid = c.session_id
WHERE a .spid > 50
and a .spid <> @@spid
and a .cmd <> 'AWAITING COMMAND'
order by spid
相关文章
- SQL Server索引视图以(物化视图)及索引视图与查询重写
- SQL Server中的死锁
- IIS安全工具UrlScan介绍 ASP.NET 两种超强SQL 注入免费解决方案( 基于IIS,使用免费工具) 批改或隐藏IIS7.5的Server头信息 移除X-Powered-By,MVC,ASP.NET_SessionId 的 HTTP头或者cookie名称
- SQL Server查询已锁的表及解锁
- SQL Server参数化查询中应用Like
- 八、Sql Server 基础培训《进度8-查询多种写法》(实际操作)
- SQL Server数据库大型应用解决方案总结
- SQL2005 : 如何在SQL Server Profiler (事件查看器)中 跟踪查看死锁恢复
- SQL Server调优系列进阶篇(查询语句运行几个指标值监测)
- SQL Server调优系列基础篇 - 子查询运算总结