Azure Arc-enabled SQL Managed Instance enables the deployment of Azure SQL data services anywhere. Microsoft promises to deliver this service with total compatibility with the SQL server database engine and integrated management capabilities. The Azure Arc-enabled SQL Managed Instance was deployed on the PowerFlex platform from the Azure portal.

All the client tools are installed and upgraded to the latest available versions as per the Azure Arc data services pre-requisites. Azure Arc data controller is installed in direct connectivity mode.

Perform the following steps to deploy the Azure Arc-enabled managed SQL instance on the PowerFlex platform:

1. Log in to the Azure Arc data controller. 

Log in to Azure Data CLI with the Azure Arc data controller details to ensure that the data controller is present and running. Enter the namespace, username, and password of the data controller to log in.

PS C:\Users\Admin>  Azure Data CLI login

Namespace: arc

Username: admin

Password:

Logged in successfully to `https://192.168.150.122:30080` in namespace `arc`. Setting active context to `arc`.

2. Create the Azure Arc-enabled SQL Managed Instance. 

The Azure Arc SQL managed instance is created from the Azure portal. The following set of values is passed as input parameters – resource group, custom location, compute, storage, and administrative account details.

Figure 13. Azure Arc-enabled SQL Managed Instance deployed on the PowerFlex platform

The custom location must be the location on which the data controller is installed. The memory size and CPU values are passed as per the requirement. The storage parameters include data, log and backup volume size, and storage class names.

3. Verify the creation of an Azure Arc-enabled SQL Managed Instance.

The Azure Arc-enabled SQL Managed Instance state is verified by using the following Azure Data CLI command:

PS C:\Users\Admin>  Azure Data CLI arc sql mi list

Name     PrimaryEndpoint        Replicas    State

-------  ---------------------  ----------  -------

sqldemo  192.168.150.122,30719  1/1         Ready

The Kubernetes cluster is verified by checking if the status of the sqldemo pod is Running.

4. Connect to the Azure Arc-enabled SQL Managed Instance from the Azure Data Studio. 

From the Azure Data Studio, connect to the deployed Azure Arc-enabled SQL Managed Instance by entering the endpoint and credentials.

Figure 14. Deployed Azure Arc-enabled SQL Managed Instance

5. Monitor and manage the Azure Arc-enabled SQL Managed Instance.

The deployed Azure Arc-enabled SQL Managed Instance is monitored and managed from the Azure portal and Azure Data Studio that is installed on the Windows client machine.

Figure 15. Monitor and manage the Azure Arc-enabled SQL Managed Instance

Note: For more information, see the Features and Capabilities of Azure Arc-enabled SQL Managed Instance.