Note Distributed availability groups in SQL Server 2016 support failover only from one availability group to another by using the option FORCE_FAILOVER_ALLOW_DATA_LOSS. When using transactional ...

On [!INCLUDE ssNoVersion_md] and SQL Managed Instance, sys.dm_tran_locks requires VIEW SERVER STATE permission. On SQL Database Basic, S0, and S1 service objectives, and for databases in elastic pools ...