Hi,
Our production environment recently have been witnessing spike in CPU utilization of more than 90% when executing some queries in a stored procedure. Though we are optimizing the stored procedure, but it will not be much of the help. Also the same stored procedure used to run properly till last week and hence we would like to know what other reason could be for such sudden spike. We have also updated the statistics and performed reindexing/rebuilding of the tables but still the high cpu utilization continues.
Kindly guide for further action.
Regards,
Saumik Vora
Is the cardinality of the data set changing? What about memory pressure, have you checked?
😎
Can you please post the actual execution plan and any other relevant information please?
Well its an order table so yes it keeps on changing. Will not be able to give atcual execution plan due to company policy.