AlwaysOn Availability Groups - Handling of Instance Level Objects
In todays implementation when using AlwaysOn Availability Groups the DBA has to take care of the so called Instance Level Objects.
Without this an (automatic) failover will fail so this is a very sensitive and important task.
Instance Level Objects span a multitude of objects like logins, SSIS packages or other binaries, Agent Jobs/Schedules, Linked Servers, encryption keys and certificates.
The recommendation provided by you is to create automated jobs to sync these items regularly.
I request that you provide these 'syncing' functionality as part of the product out-of-the-box.
Clearly you cannot know 3rd party dependencies nevertheless there are a log of items which are within your control.
Be aware that this is the core issue for people in my organization NOT to use AOAG and instead look and AO FCI.
If you want to extent the usage of AOAG (at least in my organization) then this would be the core lever.
("Make handling of instance level objects in AOAG as easy as in FCI.")
MSFT is doing wonders and Nadella pushing Data platform to above and beyond. Why it is so complex for SQL development team to do AG compare for instance level objects ? I did not see this in 2019 feature set. Hope it will be ready in RTM
Kevin Hill commented
At the very least a "checkup" option to compare instances...like Schema Compare but "AG Compare" for the most commonly used things needed for a successful failover