% Processor Time on a Multi-Processor Machine

duck · Post by **duck** » Thu Oct 31, 2002 2:59 pm

How do you calculate the % Processor Time on a Multi-Processor machine?

I have a Performance Counter Test that measures the % Processor Time for sqlservr. According to the Windows Performance Monitor the process is running about 140% (this is normal for some of our machines), but Host Monitor is only reporting 100%.

Is it possible that Host Monitor 3.40 is not calculating this correctly on a multi-processor machine?

KS-Soft · Post by **KS-Soft** » Thu Oct 31, 2002 7:02 pm

H'm, Performance Counter test does not calculate anything, it just inquires Windows and displays result...

Regards
Alex

duck · Post by **duck** » Fri Nov 08, 2002 12:40 pm

I still don't understand. This is a two processor box, so when Performance Monitor shows 150%, the task manager shows 75% for the sqlsrvr process. I wrote a VB Script to calculate the % Processor using Win32_PerfRawData_PerfProc_Process and I get the 150% in the Performance monitor. Could this be a future enhancement to calculate the a process PercentCPU according to http://msdn.microsoft.com/library/defau ... rocess.asp

y.beyet · Post by **y.beyet** » Thu Feb 13, 2003 8:07 am

Alex, Could you please report "bad status" instead of a value over 100%, the log analyser show so bad display when i have this problem...

[ This Message was edited by: y.beyet on 2003-02-13 07:07 ]

KS-Soft · Post by **KS-Soft** » Fri Feb 14, 2003 12:33 am

What do you mean "log analyser show so bad display"? Does it display something wrong? Or you just don't want to have report with values over 100%?

Regards
Alex

y.beyet · Post by **y.beyet** » Fri Feb 14, 2003 6:35 am

I have sometimes results over 10000% on one server, you can imagine the result in the display with other values between 0 and 100%.

And yes, if value over 100% are wrong, they should not be displayed.

[ This Message was edited by: y.beyet on 2003-02-14 05:39 ]

KS-Soft · Post by **KS-Soft** » Fri Feb 14, 2003 12:09 pm

H'm.. Do you have single-processor or multi-processor system?

Regards
Alex

y.beyet · Post by **y.beyet** » Mon Feb 17, 2003 2:05 am

multi-processor one under nt4.

KS-Soft · Post by **KS-Soft** » Tue Feb 18, 2003 12:18 am

Could you try to use CPU Usage test instead of Performance Counter? CPU Usage test acesses to the same performance data but it does not use pdh.dll. May be it will show another results?

Regards
Alex

y.beyet · Post by **y.beyet** » Tue Feb 18, 2003 2:00 am

i use CPU usage test.
We have tried a lot of thing about that problem a few month ago...
I'am just searching a best issue for this problem

[ This Message was edited by: y.beyet on 2003-02-18 05:57 ]

hmo · Post by **hmo** » Tue Feb 18, 2003 3:46 pm

... just a short notice regarding this topic:

CPU monitoring by Performance Counter (mode: OneByOn) work on W2K and XP. You can even monitor single CPU- or 2,3 and 4 together!

On the other hand... the use of "CPU usage" directly does not show the "right" value in multiple CPU system (not here anyway).

Cheers,
Hans Mosegaard

KS-Soft · Post by **KS-Soft** » Wed Feb 19, 2003 6:21 pm

You will laugh, but we don't have any multi-processor system. Could you please start test program (available at http://www.ks-soft.net/download/cputest2.exe) and send screen shot to line2@ks-soft.net?

Regards
Alex

hmo · Post by **hmo** » Tue Feb 25, 2003 12:54 am

Sure!
A screendump is on the way through cyberspace!
Cheers,
Hans Mosegaard