Solved

\Process(sqlservr)\% Processor, why is higher then total processor time, how to calculate them ?

Posted on 2011-02-16
3
723 Views
Last Modified: 2012-05-11
\Process(sqlservr)\% Processor Time show me I have 457.172116158291% of usage. But total processor time only show me 100%.
Actually how this calculation work ? in our server we have 4CPu.

0
Comment
Question by:motioneye
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
guvera earned 500 total points
ID: 34904542
Hi,

 Counter                                                 Description
 Process\% Processor Time                -  The sum of processor time on each processor for all threads of  the process.

Processor(_Total)\% Processor Time  -  A measure of processor activity for all processors in the computer.This counter sums the average nonidle time of all processors during the sample interval and divides it by the number of processors. For example, if all processors are busy for half of the sample interval, on average, it displays 50%. It also displays 50% if half of the processors are busy for the entire interval, and the others are idle.

Thread\% Processor Time                   -  The amount of processor time for a thread.
 
Although these two counters are named the same, they are calculated quite differently:

 

The % Processor Time for the _Total instance under the Processor object shows an AVERAGE of the processor used across all cpus (we have 8.) , so if 2 are 10% and 6 at 5% the the counter shows around 6%. On the other hand, the % Processor Time under the Process object for the sqlserver instance shows a SUM of all the processors. so if 2 are 10% and 6 at 5% then the counter shows 50%.

 Hope it may helpful to you.

Regards
Guvera



0
 

Assisted Solution

by:motioneye
motioneye earned 0 total points
ID: 34906616
HI guvera,
You copy this on net. I would appreciate if you or someone here can explain on his way.
0
 

Author Closing Comment

by:motioneye
ID: 35042834
Expert comment base on article on net
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question