createtable#Temp(spid smallint,status nchar(30),hostname nchar(128),program_name nchar(128)
,cmd nchar(16),cpu int,physical_io int,blocked smallint,dbid smallint
,loginame nchar(128),last_batch datetime
,SQLBuffer nvarchar(4000),BlockedSQLBuffer nvarchar(4000))
--保存DBCC InputBuffer 的结果
createtable#Temp1(id intidentity(1,1),eventtype varchar(20),parameters int,eventinfo nvarchar(4000))
createtable#Temp_b(id intidentity(1,1),eventtype varchar(20),parameters int,eventinfo nvarchar(4000))
select*into#Temp2
frommaster..sysprocesses (nolock)
--保存被阻塞的进程信息
insertinto#Temp(spid ,status ,hostname ,program_name ,cmd ,cpu ,physical_io ,blocked ,dbid
,loginame ,last_batch )
SELECTspid ,status ,hostname ,program_name ,cmd ,cpu ,physical_io ,blocked ,dbid
|