A SQL managed instance closely resembles an on-premises [!INCLUDE ssNoVersion] instance, without the need to worry about hardware failure or patching. SQL Managed Instance is a collection of system ...
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 ...