Ensure Expensive Queries are Recompiled
Brent Ozar would love a “Cost Threshold for Recompile” setting, and I would to. But until Microsoft add this feature, here is a stored procedure that you can run once an hour, to do just that.
There is a file which will create a job on SQL Agent, if you have a SQL Agent. If you don't, there is a small script that shows how you can create an Elastic Job in Azure SQL Agent
Read all about his suggestion here: https://lnkd.in/eeTeh2E