Optimize For Ad Hoc Workloads

The optimize for ad hoc workloads setting can be used to improve the efficiency of the execution plan cache, particularly for systems when there are a large number of ad hoc or single-use queries.

Suggested Action

Enable the backup checksum setting.

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.

Further Reading

Optimize for ad hoc workloads | Microsoft Docs