Is there a way to know how much CPU (in %) is being used by a query that is currently being runninng?
or What is exactly using CPU in % from the database level or database process
I tried to look into MDA tables
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.
topas shows dataserver using morethan 50% CPU
Name PID CPU% PgSp Owner
dataserv 10420394 55 27.4M sybe30
disp+wor 35389690 0.9 230M e30adm
Environment: SAP ASE 15.7 SP121 on AIX 7.1 for a mixed OLTP and OLAP
Appreciate any feedback.