select (select SUM(physical_io) from sys.sysprocesses
where spid=a.Spid
)physical_io,(select SUM(cpu) from sys.sysprocesses
where spid=a.Spid
)cpu,*
from master.DBAdmin.VV_查看当前正在执行的SQL语句 a
order by start_time
--where ISNULL(wait,'')='RESOURCE_SEMAPHORE'
--dbcc inputbuffer(337)
--kill 186