The solution to detect the query execution plan changes. There were instances execution plan changed over the period of time for stored procedure and created a slowness in production. SQL server 2012 and prior versions not provides out of box capability to detect the query plan changes. This solution developed for that reason. The collected …
Author Archives: mahadevantech
Troubleshoot SQL CPU spikes
In this blog, I am covering an approach to troubleshoot and find SQL queries when there is spike in Server CPU. There would be scenario where the CPU on server was pegged at 100% for approx. 10 minutes yesterday at 4:00pm. In this case how do you find out what sql was running against the …
Maha's blog 