Solved

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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

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 I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.

808 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