High CPU Utilization

Hello,
I have one database server with 4 CPU's. Normally the server has no problems
and the server has a lot of free CPU and memory for SQL Server. Since
yesterday the CPU's are completely crazys and in all of them have the
%processor time rises above 80%
In taskmgr i see sqlsrvr.exe w/ CPU utilization between 60 and 80 percent.
Have u any ideas to start trobleshooting this problem? Is it possible that
the cause of this problem its being produced by code executed(any stored
proc, etc, etc...)
Hope that you can help me.
Thanks and best regardsGo onto your server and have a look at 'Task Manager' to see which process i
s
causing the most CPU time.
We had a similar issue with backups. It seemed to clear itself after about a
day.
Peter
"All generalizations are false, including this one."
Mark Twain
"CC&JM" wrote:

> Hello,
> I have one database server with 4 CPU's. Normally the server has no proble
ms
> and the server has a lot of free CPU and memory for SQL Server. Since
> yesterday the CPU's are completely crazys and in all of them have the
> %processor time rises above 80%
> In taskmgr i see sqlsrvr.exe w/ CPU utilization between 60 and 80 percent.
> Have u any ideas to start trobleshooting this problem? Is it possible that
> the cause of this problem its being produced by code executed(any stored
> proc, etc, etc...)
> Hope that you can help me.
> Thanks and best regards
>