Docs state this: "... ALTER ANY DATABASE EVENT SESSION permission in the database."

Did you test that ?

What you're trying to do doesn't make much sense to me, but you need to build "dynamic sql" for the "create view" statement you are trying to generate and implement.

indeed, nowadays DBATOOLS is the way to go!

https://docs.dbatools.io/Restore-DbaDatabase

DTC just coördinaties the transactions!

Stay away of linked servers as much as you can!

Chances are the sql instance that runs your sql statement ( join with linked server involved )...

If you need it quick and want to avoid buying the wrong hardware ....

Go for an Azure SQLDatabase ! ( subscription based, flexible, shrink/enlarge capacity as you need)

Add and AzureVM...

What are the criteria with which you determine a row to be red or green ?

did you try a solution using a windowing function ?

WITH cteRwNos
     AS (SELECT a1.[TxID]
         ...

Posting your solution would be very much appreciated.

did you check with Common Causes and Troubleshooting Solutions for SQL AG Data Synchronization Latency

indeed that setting reverses.

btw the errorlog file is so polluted with SQLMI loggings of backups etc, and are not persisted over failovers

Have a look at my little article "Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"

Thank you for the feedback!

and kick the designer in a place where it hurts ...

It is a best practice to follow up on SP & CU for your sqlserver version. Especially inspect for issues you experience.

Here's a prep list I found on one of...

The biggest down side of an in-place upgrade is that is keeps things working, hence it may leave fixed issues open to keep it working with the settings of SQL2008.

That...