High CPU Usage

Hello,

I need your help urgently.

I have a MsSQL server database that behaves normally all day, but at certain
times the server's cpu usage rises abnormally.

There's no increase in the amount of transactions sent to the server,
there's no scheduled job running, and apparently there's no other
application running on the server.

Could you tell me the tools availble to identify what's the cause of the
high CPU usage???  with Perfomance monitor I get the %Processor Time but I
don't get the source of the problem.

Any ideas,

TIA

Eduardo Sicouret

You can go into task manager and select the "Processes" tab.  Once there
click the CPU column to sort it.... this should show you which
process/application is using the CPU the most.

HTH
--
Adam J Warne, MCDBA


"Eduardo Sicouret" wrote:

> Hello,
>
> I need your help urgently.
>
> I have a MsSQL server database that behaves normally all day, but at certa
in
> times the server's cpu usage rises abnormally.
>
> There's no increase in the amount of transactions sent to the server,
> there's no scheduled job running, and apparently there's no other
> application running on the server.
>
> Could you tell me the tools availble to identify what's the cause of the
> high CPU usage???  with Perfomance monitor I get the %Processor Time but I
> don't get the source of the problem.
>
> Any ideas,
>
> TIA
>
> Eduardo Sicouret
>
>
>

I get that SQL server is the process that's taking the most CPU time...  but
I don't know what is it doing

Eduardo
"Adam Warne" < AdamWarne@discussion
s.microsoft.com> escribió en el mensaje
news:AE07D8AD-7AAA-40F0-86B2- 0CBA02854D42@microso
ft.com...
> You can go into task manager and select the "Processes" tab.  Once there
> click the CPU column to sort it.... this should show you which
> process/application is using the CPU the most.
>
> HTH
> --
> Adam J Warne, MCDBA
>
>
> "Eduardo Sicouret" wrote:
> 

My apologies Eduardo, I misread the question .... one of those days.

In this instance, you could run a trace through SQL profiler to see what
transactions are running when the CPU usage peaks.

Alternatively, you can execute "sp_who2" and this will show you the spids
that have a high CPU time.  You can then run "dbcc inputbuffer (spid)" to se
e
what command is being executed for that spid.

--
Adam J Warne, MCDBA


"Eduardo Sicouret" wrote:

> I get that SQL server is the process that's taking the most CPU time...  b
ut
> I don't know what is it doing
>
> Eduardo
> "Adam Warne" < AdamWarne@discussion
s.microsoft.com> escribió en el mensaje
> news:AE07D8AD-7AAA-40F0-86B2- 0CBA02854D42@microso
ft.com... 
>
>
>