This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 60%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Is setting Optimize for Ad hoc Workloads to true for sql 2017/2019 a best practise.
Hi @Vishu ,
Welcome to Microsoft Q&A!
Before you enable Optimize for Ad hoc Workloads, you should test it first. Please refer to this thread, see below:
Best regards,
Carrin
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Is setting Optimize for Ad hoc Workloads to true for sql 2017/2019 a best practise.
If it would, then the option would be set to "True" by default; which isn't.
So it depends on the workload of your SQL Server if you should set it or not.
See optimize for ad hoc workloads Server Configuration Option for more details
Yes, it is generally best practice to turn on this option. The option is kind of band-aid for poorly written applications, but your workload would have to be quite special to suffer from it.