Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2011-02-16
3
Medium Priority
?
768 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
guvera earned 2000 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
In this article I will describe the Copy Database Wizard 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.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

721 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