% Processor Time on a Multi-Processor Machine

duck · Joined: 24 Oct 2002 Posts: 2

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 · Joined: 03 Apr 2002 Posts: 12795 Location: USA

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

Regards
Alex

duck · Joined: 24 Oct 2002 Posts: 2

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/default.asp?url=/library/en-us/wmisdk/wmi/win32_perfrawdata_perfproc_process.asp

y.beyet · Joined: 16 Apr 2002 Posts: 62 Location: France

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 · Joined: 03 Apr 2002 Posts: 12795 Location: USA

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 · Joined: 16 Apr 2002 Posts: 62 Location: France

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 · Joined: 03 Apr 2002 Posts: 12795 Location: USA

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

Regards
Alex

y.beyet · Joined: 16 Apr 2002 Posts: 62 Location: France

multi-processor one under nt4.

KS-Soft · Joined: 03 Apr 2002 Posts: 12795 Location: USA

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 · Joined: 16 Apr 2002 Posts: 62 Location: France

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 · Joined: 14 Feb 2003 Posts: 81 Location: Denmark

... 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 · Joined: 03 Apr 2002 Posts: 12795 Location: USA

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 · Joined: 14 Feb 2003 Posts: 81 Location: Denmark

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