Whats the output of this code snippet?


select value_in_use from sys.configurations where name = 'backup compression default'


If it's 1 the default setting is to compress...

Perfectly acceptable depending on requirements.

Read up on both of the settings as each isolation level does different things

https://blog.sqlauthority.com/2015/07/03/sql-server-difference-between-read-committed-snapshot-and-snapshot-isolation-level/

Are you using the SSIS catalog (project deployment) or are you doing the old FileSystem / MSDB (package deployment) methods to deploy your SSIS solutions?

If the new version,...

Personally I would create the cluster at the start, all be it a 1 node cluster and enable the AOAG feature, as doing that later needs a restart of the...

Bond