Solved

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

Posted on 2011-02-16
3
687 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
Comment Utility
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
Comment Utility
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
Comment Utility
Expert comment base on article on net
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

771 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

10 Experts available now in Live!

Get 1:1 Help Now