Performance counter quest

Hi,
SQL2000 Standard sp3.
Windows 2000 server, 2 physical processors, Intel hyper threading tech.
I am running Performance monitor from another machine which is Windows 2000
terminal , to monitor the above mentioned sqlserver. The output of the csv f
ile showing total processor time > 300. I dont understand why it is showing
instead of values < 100. I
n that machine i can see .NET CLR counters also. Is this behaviour because o
f .NET?
(PDH-CSV 4.0) (Pacific Daylight Time)(420) \\AB01\Process(_Total)\% Privileg
ed Time \\AB01\Process(_Total)\% Processor Time
4/13/04 5:00 AM 349.7912317 399.6868476
4/13/04 5:00 AM 350 399.8958333
4/13/04 5:00 AM 399.7918835 399.8959417
4/13/04 5:01 AM 343.8541667 399.6875
How can i take the processor time to calculate cpu usage? Any help appreciat
ed
thanks
krisLook at the Processor(_Total)\% Processor Time for values that you expect.
Some of the counters are explained at :
http://www.extremeexperts.com/sql/a...QLCounters.aspx
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"kris" <anonymous@.discussions.microsoft.com> wrote in message
news:BF219D19-16FC-40DD-8728-31A2E8E2580A@.microsoft.com...
> Hi,
> SQL2000 Standard sp3.
> Windows 2000 server, 2 physical processors, Intel hyper threading tech.
> I am running Performance monitor from another machine which is windows
2000 terminal , to monitor the above mentioned sqlserver. The output of the
csv file showing total processor time > 300. I dont understand why it is
showing instead of values < 100. In that machine i can see .NET CLR
counters also. Is this behaviour because of .NET?
> (PDH-CSV 4.0) (Pacific Daylight Time)(420) \\AB01\Process(_Total)\%
Privileged Time \\AB01\Process(_Total)\% Processor Time
> 4/13/04 5:00 AM 349.7912317 399.6868476
> 4/13/04 5:00 AM 350 399.8958333
> 4/13/04 5:00 AM 399.7918835 399.8959417
> 4/13/04 5:01 AM 343.8541667 399.6875
> How can i take the processor time to calculate cpu usage? Any help
appreciated
> thanks
> kris
>
>