Re: Performance counter quest

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Vinodk (vinodk_sct_at_NO_SPAM_hotmail.com)
Date: 04/14/04 

Date: Wed, 14 Apr 2004 09:49:36 +0530

Look 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
>
>
>

Relevant Pages

  • Re: MSCS Questions
    ... The SQL Server is set to dynamically use up to 3072 MB ... System: %Total Processor Time; ... Memory: Pages/Sec; ... Among several other counters, including network I/O counters and thread ...
    (microsoft.public.sqlserver.server)
  • sqlservr.exe doesnt stop
    ... >take all available processor time without me asking it to ... >stop it through Service Manager and if I do it ... >won't let me restart again. ... >computer but as soon as I tried to access SQL Server I ...
    (microsoft.public.sqlserver.security)
  • Re: What process is causing occasional Pages/Sec spikes?
    ... Running SQL Server 2005 SP2. ... Disk Queue length and % Processor Time), ... spike and then settles right back to the bottom again for anywhere between ...
    (microsoft.public.sqlserver.server)
  • Re: sqlservr.exe doesnt stop
    ... > I have SQL SERVER 2000 Developer installed on my computer. ... > take all available processor time without me asking it to do it. ... > stop it through Service Manager and if I do it just "stopping" for ever ... > won't let me restart again. ...
    (microsoft.public.sqlserver.security)
  • Re: sqlservr.exe doesnt stop
    ... Have you tried stopping sql server from the command prompt using: ... >> take all available processor time without me asking it to do it. ... >> won't let me restart again. ... >> Did I get some kind of virus? ...
    (microsoft.public.sqlserver.security)