Sqlserver活动视图

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