Skip to content

Latest commit

 

History

History
83 lines (55 loc) · 3.88 KB

support-for-fci.md

File metadata and controls

83 lines (55 loc) · 3.88 KB
title description author ms.author ms.reviewer ms.date ms.topic
View Always On failover cluster instances
In this article, you learn how you can view and manage SQL Server instances enabled by Azure Arc that are configured as a failover cluster.
AbdullahMSFT
amamun
mikeray, randolphwest
05/08/2024
how-to

View Always On failover cluster instances in Azure Arc

[!INCLUDE sqlserver]

Azure portal provides information about SQL Server failover cluster instances when they are enabled by Azure Arc. The Azure SQL extension agent must be installed on all the nodes of the SQL Server failover cluster instance. The agents project the installation into Azure as a SQL Server enabled by Azure Arc resource.

For details about failover cluster instances, review Always On failover cluster instances (SQL Server).

Important

[!INCLUDE latest-features]

You can see all the resources like network name, databases and all the nodes in the corresponding resource group.

List failover cluster instances

In Azure portal, Azure Arc | SQL Server instances lists all instances of SQL Server that are enabled by Azure Arc.

To list only the failover cluster instances:

  1. Select Add filter.

  2. Set Filter to SQL Server instance type equals Failover Cluster Instance.

  3. Select Apply.

    :::image type="content" source="media/support-for-fci/filter-portal.png" alt-text="Screenshot of Azure portal for Azure Arc SQL Server add filter control." lightbox="media/support-for-fci/filter-portal-expanded.png":::

The portal returns only the failover cluster instances.

View failover cluster instance

To view the properties of a failover cluster instance:

  1. Select a SQL Server - Azure Arc resource that is a failover cluster instance type.

  2. Select Overview.

  3. Review the properties under Essentials.

    :::image type="content" source="media/support-for-fci/essentials.png" alt-text="Screenshot of Azure portal for failover cluster instance enabled by Azure Arc." lightbox="media/support-for-fci/essentials-expanded.png":::

Inventory upload state

The portal describes the failover cluster instance state. For example:

  • Instance name
    • Default instance <NetworkName>
    • Named instance <NetworkName>_<InstanceName>
  • Instance type
  • Network name
  • Active nodes
  • Passive nodes

Information reflects the state at Inventory upload time. The view doesn't reflect changes or failovers after that time. The next upload will show the new active node or the updates made. Information upload is scheduled hourly.

View databases

To view the databases on a failover cluster instance:

  1. Browse to the resource - either <NetworkName> or <NetworkName>_<InstanceName>.
  2. Select Data management > Database.

The portal displays the databases on the SQL Server instance.

Limitations

  • All the Windows and SQL Server instances that are part of the failover clustering should be in same resource group.
  • Always On availability groups on a failover cluster instance aren't supported for [!INCLUDE ssazurearc] at this time.
  • Currently, best practices assessment isn't supported with Always On failover cluster instance.
  • Automated backups and point-in-time restore isn't supported for failover cluster instances at this time.
  • SQL failover cluster instances with multiple network names aren't supported at this time.
  • In the local Windows Server Failover Cluster (WSFC), the clustered resource group (role) name should not contain a backslash ("\").
  • For extension versions older than 1.1.2620.127, SQL failover cluster instances with a different network name than the one configured during installation aren't supported.

Related tasks