-
Detecting Query Plan Changes
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… Read more
-
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… Read more
Follow My Blog
Get new content delivered directly to your inbox.
Maha's blog 