Automatic Tuning: Execution Plan Correction
Have you ever noticed that execution plans changed? Is your performance suffering due to the change? If so, Automatic Plan Correction is for you. In our previous blog post, we identified scalar function improvements, parameter sniffing and data skew. In this post, we are going to show you how SQL Server 2017 can automatically help improve your performance. This is done by changing executions plans to improve your performance.
How does Automatic Plan Correction work?
Great question. Go ahead and watch the short video below to see for yourself.
This is a great post. Thanks John!
Misha,
I am glad you enjoyed the post. Let me know if there are any other topics you would like to see in future blog posts.
Regards,
John