Skip to Content
Feb 02, 2015 at 01:13 PM

how much CPU (in %) is being used by a database process?



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.