MDA: Who is using most CPU resources.

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


Replace CpuTime with LogicalReads or PhysicalReads as required