https://communities.sas.com/t5/SAS-Procedures/CPU-Time-lower-than-Real-Time/m-p/25598#M5792 Hi all,<BR /> <BR /> Ran a query containing a join on two relatively large datasets. Added the fullstimer option.<BR /> <BR /> 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?<BR /> <BR /> Regards,<BR /> Tomas. Fri, 04 Dec 2009 08:52:24 GMT deleted_user 2009-12-04T08:52:24Z https://communities.sas.com/t5/SAS-Procedures/CPU-Time-lower-than-Real-Time/m-p/25598#M5792 Hi all,<BR /> <BR /> Ran a query containing a join on two relatively large datasets. Added the fullstimer option.<BR /> <BR /> 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?<BR /> <BR /> Regards,<BR /> Tomas. Fri, 04 Dec 2009 08:52:24 GMT https://communities.sas.com/t5/SAS-Procedures/CPU-Time-lower-than-Real-Time/m-p/25598#M5792 deleted_user 2009-12-04T08:52:24Z https://communities.sas.com/t5/SAS-Procedures/CPU-Time-lower-than-Real-Time/m-p/25599#M5793 Yep.<BR /> <BR /> That's because you're running on a multi-cpu platform.<BR /> <BR /> The reported CPU time, sums every CPU time dedicated to the task.<BR /> <BR /> Cheers from Portugal<BR /> <BR /> Daniel Santos @ <A href="http://www.cgd.pt" target="_blank">www.cgd.pt</A> Fri, 04 Dec 2009 09:21:49 GMT https://communities.sas.com/t5/SAS-Procedures/CPU-Time-lower-than-Real-Time/m-p/25599#M5793 DanielSantos 2009-12-04T09:21:49Z https://communities.sas.com/t5/SAS-Procedures/CPU-Time-lower-than-Real-Time/m-p/25600#M5794 Useful search argument on the topic:<BR /> <BR /> performance fullstimer cpu real time site:sas.com<BR /> <BR /> SAS support KB reference, Scalability and Performance Community <BR /> <A href="http://support.sas.com/rnd/scalability/index.html" target="_blank">http://support.sas.com/rnd/scalability/index.html</A><BR /> <BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> <A href="http://support.sas.com/rnd/scalability/tools/fullstim/index.html" target="_blank">http://support.sas.com/rnd/scalability/tools/fullstim/index.html</A><BR /> <BR /> <A href="http://support.sas.com/rnd/papers/sugi27/SolvingPerformance.pdf" target="_blank">http://support.sas.com/rnd/papers/sugi27/SolvingPerformance.pdf</A> Fri, 04 Dec 2009 15:16:55 GMT https://communities.sas.com/t5/SAS-Procedures/CPU-Time-lower-than-Real-Time/m-p/25600#M5794 sbb 2009-12-04T15:16:55Z