Create SQL assessment

This article to create SQL assessments for migration to Azure, targeting different Azure PaaS and laaS options using Azure Migrate. By creating as assessment for your SQL instances, you'll receive recommended target environments and key insights, such as readiness, target right-sizing, and monthly costs for hosting and running these applications.

Prerequisites

• Deploy and configure the Azure Migrate appliance in your VMware, Hyper-V, or physical environment.
• Check the appliance requirement Azure Migrate appliance URL access
• Migration to App Service Environment v3 using the in-place migration feature to discover web applications running in your environment.

Create a workload assessment for webapps

1. On the Azure Migrate project overview page, under Decide and plan, select Assessments.

   

2. In Assessments page, select Create assessment.

   

3. Provide a suitable name for the assessment, then select Add workloads.

   

4. Use the appropriate filters, select the webapp and then select Add.

   

5. Select Review the selected workloads and then select Next.

   

6. On the General tab, modify the assessment settings that apply to all Azure targets.

   

   Settings	Possible values	Comments
   Default target location	All locations supported by Azure targets	Used to generate regional cost for Azure targets.
   Default Environment	Production Dev/Test	Allows you to toggle between pay-as-you-go and pay-as-you-go Dev/Test offers.
   Currency	All common currencies such as USD, INR, GBP, Euro	We generate the cost in the currency selected here.
   Program/offer	Pay-as-you-go Enterprise Agreement	Allows you to toggle between pay-as-you-go and Enterprise Agreement offers.
   Default savings option	One year reserved Three years reserved One year savings plan Three years savings plan None	Select a savings option if you've opted for Reserved Instances or Savings Plan.
   Discount Percentage	Numeric decimal value	Use this option to factor in any custom discount agreements with Microsoft. It's disabled if Savings options are selected.
   EA subscription	Subscription ID	Select the subscription ID for which you have an Enterprise Agreement.
   Default savings options	One year reserved Three years reserved One year savings plan Three years savings plan None	Select a savings option if you've opted for Reserved Instances or Savings Plan.
   Microsoft Defender for Cloud	-	Includes Microsoft Defender for App Service costs in the month-over-month cost estimate.

7. On the Advanced tab, select Edit defaults and then select the preferred Azure targets and configure target-specific settings.

   

AKS settings: The following table details about the AKS settings.

Settings	Possible values	Comments
Category	All Compute optimized General purpose GPU High performance compute Isolated Memory optimized Storage optimized	Selecting a specific SKU category ensures that we recommend the best AKS node SKUs from that category.
AKS pricing tier	Standard	Pricing tier for AKS
Consolidation	Full Consolidation	Maximize the number of webapps to be packed per node.

App service settings: The following table details the App service settings

Settings	Possible values	Comments
Isolation required	No Yes	The isolated plan enables customers to run their apps in a private, dedicated environment within an Azure data center, using Dv2-series VMs with faster processors, SSD storage, and double the memory-to-core ratio compared to Standard VMs.

Now, review and create the assessment.

Next steps

• Understand the assessment insights to make data-driven decisions for web app modernization
• Optimize Windows Dockerfiles.
• Review and implement best practices to build and manage apps on AKS.