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
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 ?