Creating an Azure SQL Managed Instance is a straightforward process; all you need to do is follow these steps:
- Navigate to All services and search for SQL managed instance; fill in the following fields:
- Click on it, and a new blade will open; click on Add, and a new blade will open, where you have to specify the following:
- Subscription: Specify the subscription that will be charged for using this service
- Managed instance name: Specify a descriptive name for the managed instance
- Managed instance admin login: Specify the admin of the managed instance
- Password: Specify a strong password for the managed instance
- Location: Select the nearest region to the service/application that will work with the managed instance.
- Virtual network: You have two options, as follows:
- Create a new virtual network: This option will create a new virtual network, compliant with the rules required for the SQL Managed Instance.
- Select one of the virtual networks/subnets that you already have.
- Resource group: Select the resource group in which it will exist as a resource.
- Pricing tier: Select one of the types that were covered in the previous section, in order to fulfill the needs of your applications. You also need to set the number of vCores and the storage size that you need. It supports two compute generations, as follows:
- Gen 4: Based on Intel E5-2673 v3 (Haswell) 2.4 GHz processors, this generation supports 8/16/24 vCores and storage ranging from 32 GB to 8 TB.
- Gen 5: Based on Intel E5-2673 v4 (Broadwell) 2.3 GHz processors, this generation supports 8/16/24/32/40/64/80 vCores and storage ranging from 32 GB to 4 TB.
- Once you are done, click on Create:
