Runaway CPU

For some reason, for two days now, in the morning hours
the sqlservr.exe process is using an average of 94% of the
CPU on a very powerful server.
Can anyone tell me how to determine what the problem is,
without just rebooting the server?
Here are some Buffer Manager statistics in case it helps:
Buffer cache hit ratio 3044
Buffer cache hit ratio base 3048
Page lookups/sec 405446548
Free list stalls/sec 114
Free pages 291
Total pages 207872
Target pages 207872
Database pages 190592
Reserved pages 648
Stolen pages 16989
Lazy writes/sec 1722
Readahead pages/sec 477294
Procedure cache pages 14862
Page reads/sec 616224
Page writes/sec 658045
Checkpoint pages/sec 315881
Thanks.
Allen"Allen White" <awhite_nospam@.advanstar.com> wrote in message
news:21b501c4d885$f31e0f60$a501280a@.phx.gbl...
> For some reason, for two days now, in the morning hours
> the sqlservr.exe process is using an average of 94% of the
> CPU on a very powerful server.
> Can anyone tell me how to determine what the problem is,
> without just rebooting the server?
> Here are some Buffer Manager statistics in case it helps:
> Buffer cache hit ratio 3044
> Buffer cache hit ratio base 3048
> Page lookups/sec 405446548
> Free list stalls/sec 114
> Free pages 291
> Total pages 207872
> Target pages 207872
> Database pages 190592
> Reserved pages 648
> Stolen pages 16989
> Lazy writes/sec 1722
> Readahead pages/sec 477294
> Procedure cache pages 14862
> Page reads/sec 616224
> Page writes/sec 658045
> Checkpoint pages/sec 315881
> Thanks.
> Allen
>
Turn on Profiler..
What jobs (if any) are running? Do you have maintenance plans executing
that are rebuilding indexes?
Rick Sawtell
MCT, MCSD, MCDBA|||Thanks, Rick. No maintenance plans are running. I keep a
trace running on all my production servers and have
reviewed the trace files and can see nothing that would
cause that kind of CPU activity. (The trace captures just
Batch Complete and RPC Complete activity.) I see lots and
lots of transactions, but nothing running for long periods
of time, nor anything that would be processor intensive.
Allen

>--Original Message--
>"Allen White" <awhite_nospam@.advanstar.com> wrote in
message
>news:21b501c4d885$f31e0f60$a501280a@.phx.gbl...
the[vbcol=seagreen]
helps:[vbcol=seagreen]
>Turn on Profiler..
>What jobs (if any) are running? Do you have maintenance
plans executing
>that are rebuilding indexes?
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>.
>