Sqlserver活动视图

最新推荐文章于 2024-09-14 19:55:29 发布

weixin_30340353

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量45

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/dingdingmao/archive/2012/06/12/3146482.html

版权

SELECT @@SERVERNAME  
go  
SELECT @@VERSION  
go  
--select process   
SELECT spid, kpid, blocked  
, CAST(waittime AS BIGINT) as waittime, lastwaittype, waitresource, dbid, uid  
, CAST(cpu / 1000 AS BIGINT) as cpu  
, CAST(physical_io AS BIGINT) as physical_io, memusage, login_time , last_batch , ecid   
, CAST(open_tran AS BIGINT) as open_tran, status, hostname, program_name  
, hostprocess, cmd, nt_domain, nt_username, net_address, net_library, loginame, stmt_start, stmt_end   
FROM master.dbo.sysprocesses   
where hostprocess <>

转载于:https://www.cnblogs.com/dingdingmao/archive/2012/06/12/3146482.html