Apr 21/2019 How to stop CPU Spikes as a result of parameter sniffing while the MS SQL stored procedure is executed? With one of our clients that we provide Remote DBA services, we recently encountered a situation where one of the frequently running stored procedures suddenly started consuming 100% of the CPU on the server.