Arc Enabled Data Services – 8

Deploying Arc-enabled SQL Managed Instance

Views 955

Now that we have our Azure Arc-enabled Data Controller configured and available, we can now deploy our first Arc-enabled SQL Managed Instance into our environment. As previously mentioned depending on the type of configuration required for your environment with your Arc-enabled Data Controller (Directly connected or Indirectly connected modes) this will dictate the approach available for you to setup / configure your Arc-enabled SQL Managed Instance.

For this post series we have a Directly connected mode data controller. As such we are able to perform our installation of the Arc-enabled SQL Managed Instance in any of the following ways:

• Azure Portal GUI Deployment
• Azure Data Studio GUI Deployment
• Azure Portal Cloud Shell CLI deployment
• Azure Data Studio Terminal CLI deployment
• Powershell CLI deployment

We will have a look in this post the deployment method of deploying using Azure Data Studio. The reason I am doing this is with the appropriate extensions in place, the deployment method creates a workbook that you are able to save and investigate all of the requirements allowing you to look at your requirements in your environments to allow for creating your own automated deployments utilising the CLI commands ensuring that you have a repeatable process for all future deployments.
Ensure you have been through the first post in this series and have the extensions in place in Azure Data Studio allowing you to undertake your first deployment.

  1. In Azure Data Studio, on the connections tab expand Azure Arc Controllers
  2. Click connect controller and connect to your Arc-enabled Data Controller you created from post 3 in this series
  3. Right click on your Arc-enabled Data Controller and select Manage
  4. Select New Instance
  5. Select Azure SQL Managed Instance
  6. Review and accept the EULA
  7. Populate all of the required data for your Arc-enabled SQL Managed Instance
    1. Instance Name
    2. Instance Name Admin Account and Password
    3. Choosing the appropriate service tier (GP vs BC)
    4. If you have Azure Hybrid Benefits, choose apporpriately
    5. Select your appropriately configured storage classes that have been pre-configured in the underlying kubernetes cluster
    6. Ensure your backup storage class is ReadWriteMany(RWX) capable
    7. Set your vCPU request to how many vCPU’s you need
    8. Set your vCPU limit to the maximum you want to have available
    9. Set your memory request
    10. Set your memory limit
  8. Click Deploy
  9. At this stage a notebook will open allowing you to review and deploy your Arc-enabled SQL MI

Depending on the resources provisioned on your kubernetes cluster, the deployment process time will vary. Once the deployment has completed, inside of Azure Data Studio, perform a refresh of the Manage Data Controller pane and you will see your newly provisioned Arc-enabled SQL MI as a resource.

You will also be able to see this newly provisioned resource in your Azure Portal under the Data Controller resources.

Clicking on the newly provisioned Arc-enabled SQL MI will give you your details for your newly provisioned Kibana and Grafana dashboards where you can monitor your new environment.

You will also find on this management tab your connection details for you newly provisioned Arc-enabled SQL MI. With these details you can connect to the newly provisioned instance the same as you would any other instance of SQL Server.

Take time now to investigate your newly provisioned Arc-enabled SQL MI.

In our next post we will look at restoring a database to our Azure Arc-enabled SQL Managed Instance.

Leave a Reply

Your email address will not be published. Required fields are marked *


I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting. When I am not working with the SQL Server Stack I like to get away to the Snow and spend time Snowboarding.