Пользуйтесть MDA таблицами

####### Which process is currently using the most CPU (and what's it doing?)

select ps.SPID, ps.CpuTime,
pst.LineNumber, pst.SQLText
from master..monProcessSQLText pst,
master..monProcessStatement ps
where ps.SPID = pst.SPID
and ps.CpuTime =
(select max(CpuTime) from master..monProcessStatement )
order by SPID, LineNumber
----- Change CpuTime to LogicalReads or PhysicalReads as required

#### Find out what the highest-I/O-consuming process is doing

select ps.SPID, ps.LogicalReads,ps.CpuTime,
pst.LineNumber, pst.SQLText
from master..monProcessSQLText pst,
master..monProcessStatement ps
where ps.SPID = pst.SPID
and ps.LogicalReads = (
and ps.CpuTime = (
select max(LogicalReads) from
master..monProcessStatement )
order by SPID, LineNumber