Query - Which currently executing queries are consuming the most CPU ?
From Sybase Wiki
1> select s.SPID, s.CpuTime, t.LineNumber, t.SQLText from master..monProcessStatement s, master..monProcessSQLText t where s.SPID = t.SPID order by s.CpuTime DESC 2> go SPID CpuTime LineNumber SQLText ----------- ----------- ----------- ------------------------------------------------------------------------------------------------ 21 16 1 s (1 row affected)