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 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 Tim
4/13/04 5:00 AM 349.7912317 399.686847
4/13/04 5:00 AM 350 399.895833
4/13/04 5:00 AM 399.7918835 399.895941
4/13/04 5:01 AM 343.8541667 399.687
How can i take the processor time to calculate cpu usage? Any help appreciate
thank
kriLook at the Processor(_Total)\% Processor Time for values that you expect.
Some of the counters are explained at :
http://www.extremeexperts.com/sql/articles/SQLCounters.aspx
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/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
>
>