Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

measure CPU utilization on SAP ASE

Hi All,

 

What is the best approach to collect CPU utilization

from ASE instance. ?

My main goal is to get a picture of CPU counters each minute

but be the last intrusive as possible.

i am using sysmon each minute then grab the value and save

into a table , but i believe this is not a good pratice.

another solution is to use a dbcc monitor command to start the counter

wait one minute , read it from master.sysmonitors and close the counter with another dbcc

command.

Also, there is a third option using monEngine, but as this table increment the counter

the result is not very accurate, at lest i am not getting the right result

Does anyone have another suggestion , or a better technique that can grab the value

correctly and not been intrusive as the sysmon ?

Former Member
Not what you were looking for? View more on this topic or Ask a question