Any help on this one ? We have this morning had a processor on one of servers constantly being pegged at 100% for a few minutes then varying between 80% and 100% for the last few hours.
It seems to have subsided now.
I did check all the usual suspects during the time ie replcation, open transactions, blocking - all of which seemed fine.
Any ideas on what i can check either now or in the future should this happen again - i think the boss was looking for answers but i couldnt give any
BTW we run our server in the cloud - was just wondering if we need to contact our 3rd party provider to see if any issues from their end ?