各位高手,我想用sp_who2和dbcc inputbuffer();显示当前占用最多时间或内存的进程
我的想法如下,但有错误提示,应该怎么改,谢谢!
dbcc inputbuffer(select top 1 SPID FROM SP_who2 order by CPUTime desc);
DECLARE @spid int; SELECT TOP 1 @spid = spid FROM master..sysprocesses WHERE spid > 50 ORDER BY cpu DESC DBCC INPUTBUFFER(@spid)