CPU SPIKES

Folks,
Since Friday i am seeing High CPU Spikes on our app / db server. the Sql ser
ver process is currently consuming about 60+ % cpu. There is not much going
on at the database level ? I am not sure what is causing the spikes.
This is really abnormal behaviour on the this server.
Please any help would be really appreciated
Thanks
GirishGirish wrote:
> Folks,
> Since Friday i am seeing High CPU Spikes on our app / db server. the
> Sql server process is currently consuming about 60+ % cpu. There is
> not much going on at the database level ? I am not sure what is
> causing the spikes.
Occassional spikes are pretty normal in SQL Server. Or is it a constant 60+%
CPU usage?
See the "How to Do SQL Server Performance Trend Analysis" articles series
for performance monitoring
http://www.sql-server-performance.c...tutor_part1.asp
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Have you tried running sp_who or sp_who2 to see what processes are running
stuff in sql? Run this system proc and check io and cpu cycles.
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Girish" <anonymous@.discussions.microsoft.com> wrote in message
news:CDF77CFE-DD12-4E3F-97E2-6D9FE33B15D0@.microsoft.com...
> Folks,
> Since Friday i am seeing High CPU Spikes on our app / db server. the Sql
server process is currently consuming about 60+ % cpu. There is not much
going on at the database level ? I am not sure what is causing the spikes.
> This is really abnormal behaviour on the this server.
> Please any help would be really appreciated
> Thanks
> Girish