Query - Which currently executing queries are consuming the most CPU ?

From Sybase Wiki
Jump to: navigation, search
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)
Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox