Double check configuration setting 'optimize for ad hoc workloads'

exec sp_configure 'optimize for ad hoc workloads', 1;
reconfigure

There is a vivid SQLServer community in Germany!

Maybe that's the way to go on your quest: SQLPass.de

What version of SQLServer are you on ?

SELECT SERVERPROPERTY('ProductUpdateLevel') AS ProductUpdateLevel  -- SQL 2014 SP1 CU5
     , SERVERPROPERTY('ProductUpdateReference') AS ProductUpdateReference
  ...

If I were you, I would indeed test it in SQL2019 and see how it performs.

Start with "Data migration Assistant" !

Then migrate - and follow up as Grant pointed...

I should indeed have been a bit more thoughtful and provided the nice context as you did, Grant.

A couple of sentences providing the full set of activities that are actually...

FYI

SQL Server 2019 Editions Datasheet.pdf

In your first query ( "then" part )  you only select columns of the "DROPS " table.

of course, your "ELSE" part will only get executed when it does not find...

if your storage is a SAN, you could implement Storage Replication with failover capabilities. ( Storage arranges sync )

On the newer SQLServer side ( first on SQL2012 ), you could...

• This reply was modified 4 years, 8 months ago by Johan Bijnens.

Just my 2ct:

Azure AD <> on-prem AD ! 

Granting an Azure AD user or group requires :

1 ) An Azure AD account ( user or group ) to be granted Azure...

Just wondering how the current solution performs with date/datetime data types on a larger set of logging data.

Regarding your I/O errors: You MUST investigate these as SQL Server is only raising this alert if a single I/O takes more that 15 SECONDS !

This may indeed have a...

Do you document "preferred node" in SQLServer ?

If yes, you could have a startup stored procedure checking that value to the current value and raise an alert or send an...

Have a look at powershell module dbatools ! it has very nice features to support your migration.

DBATools sql server migration enhancements

FWIW the execution plan will show the indexes it plans use ( and estimates or actual usage values )

Also keep this note in mind: "...optional for computers that do not host Microsoft SQL Server Reporting Services."