Solved

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

Posted on 2011-02-16
3
696 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

914 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now