• Hi Kenneth.
    1: Optimize for ad-hoc workloads recommendation is general, has nothing to do with the size of databases.
    2: Nothing wrong with using older compatibility modes as long as your policies for calculating statistics are aligned with the platform. My point is that when you upgrade to 120 or later, you cannot just trust auto update stats for large databases. You need to check your query plans and probable set up maintenance jobs to calculate stats.