Always on SQL Managed Instance

• Diyas

  SSCarpal Tunnel

  Points: 4851

  More actions

  January 9, 2023 at 2:49 pm

  #4135488

   

  is Always on support for the SQL managed instance.

  Distributed Queries are supported for SQL managed instances.

• Michael L John

  One Orange Chip

  Points: 27079

  More actions

  January 9, 2023 at 7:42 pm

  #4135648

  What is your question?  Can you clarify?

  If you are asking if an always on implementation can support a SQL Managed Instance, then the answer is yes.

  As for a "distributed query", are you referring to a cross database query?  If so, the answer is yes.

  If you are talking about 'Distributed transactions", the answer is also yes

  https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-transactions-overview?view=azuresql 

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/