CPU Time lower than Real Time

[deleted_user]

Hi all,

Ran a query containing a join on two relatively large datasets. Added the fullstimer option.

In the log I see the CPU time is 50% higher the Real Time. How come the CPU time is higher than the Real Time? Do the statistics of multiple CPU's used in the query get aggregated?

Regards,
Tomas.

[DanielSantos]

Yep.

That's because you're running on a multi-cpu platform.

The reported CPU time, sums every CPU time dedicated to the task.

Cheers from Portugal

Daniel Santos @ www.cgd.pt

[sbb]

Useful search argument on the topic:

performance fullstimer cpu real time site:sas.com

SAS support KB reference, Scalability and Performance Community
http://support.sas.com/rnd/scalability/index.html


Scott Barry
SBBWorks, Inc.

http://support.sas.com/rnd/scalability/tools/fullstim/index.html

http://support.sas.com/rnd/papers/sugi27/SolvingPerformance.pdf