Sqlserver活动视图

发布时间：2020-12-12 14:35:38 所属栏目：MsSql教程来源：网络整理

导读：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,memus

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 <>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!