October 30, 2008 at 6:31 am
Hi,
Just few minutes ago my production dedicated sql server experienced strange behaviour. For five minutes sqlsrvr.exe was utilizing CPU on 99% level.
I started checking, top consumer queries, locks, counters nothing showed that I experiencing such huge overload. After few minutes CPU came down to average 30-40% level.
Do you know what could cause this CPU overloading, it has never happened earlier?
Please note I have server-side trace running across the server which catches t-sql batches and procedures. Maybe trace was the problem, some generic bug and so on…
Kind regards,
Bartek
October 30, 2008 at 7:05 am
A spike for 4-5 minutes, while unusual, isn't necessarily a problem. You might have had a load that coincided with other loads. Were any queries running unusually long or a backup or file growth? File growths are better in 2005, but they can still slow the server.
October 30, 2008 at 8:35 am
Thanks for reply Steve.
Most heavy queries finished in the half time of that peak, this had been my first thought when I was checking but CPU utilization was much higher than queries CPU consumption. I have constant monitoring, none of counters showed high utilization except % Processor time. There were no backups at this time and storage counters did not show heavy write level.
Any thoughts appriciated.
December 12, 2008 at 3:45 am
have you got auto update / create stats enabled?
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
December 12, 2008 at 5:13 am
Hi Swirl,
Yes, all databases have both options turned on. Do you imply that auto statistics update could have place?
Maybe, I don't know, I will have to make deeper analysis, if any traces left. But as far I remember disk IO was low. I suppose in such task reads and writes should exists..
Regards,
Bartek
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply