Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

The counter, Process(sqlservr)\% Processor Time, is hovering around 361% on one of my database servers. This counter reflects the percent of total time SQL Server spent running on CPU (user mode + privilege mode).

Number of CPU's - 2

\\Process(sqlservr)\% Processor Time MAX - 361.35

\\Processor(_Total)\% Processor Time - 100

No.of.CPU's 2 = Processor _Total(100 * 2 = 200),How is it possible for that counter to be over 300%?

share|improve this question
1  
what's the processor? i.e. exact model –  Chopper3 Sep 30 '10 at 13:00
    
and is hyperthreading enabled? –  SqlACID Sep 30 '10 at 13:22

1 Answer 1

Do you mean 2 physical CPUs (usually referred to as 2 sockets), or a single CPU with 2 cores?

I'm guessing you may have 2 physical CPUs (sockets) and each is dual core, which effectively gives you 4 CPUs, making your maximum for the counter 400%.

share|improve this answer
    
We have 2 Physical CPU's only .. –  user55742 Sep 30 '10 at 13:13
    
I mean 2 processors only –  user55742 Sep 30 '10 at 13:19
    
I have given below the processor details ..AMD Opteron(tm) Processor 254 2 Physical Processors / One Core / One Logical Processor / 64 bits –  user55742 Sep 30 '10 at 13:23
    
Property Value CPU Name AMD Opteron 254 (2P) Property Value Platform Name Socket 940 –  user55742 Sep 30 '10 at 13:23
    
Odd, that's a single-core CPU with no hyperthreading, you really should only see two cores - very odd –  Chopper3 Sep 30 '10 at 13:31

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.