Assess migration readiness (preview) - SQL Server enabled by Azure Arc
Applies to: SQL Server
SQL Server enabled by Azure Arc, automatically produces an assessment for migration to Azure. This assessment plays a vital role in the success of your cloud migration and modernization journey. Azure Arc simplifies the discovery process and readiness assessment for migration.
The assessment:
- Provides cloud readiness, identifies risks, and offers mitigation strategies.
- Provides the specific service tier and Azure SQL configuration (SKU size) for each Azure SQL deployment option, best fits the workload needs.
- Is generated automatically.
- Runs continuously on a default schedule of once per week.
- Is free, and available for all SQL Server editions.
You can obtain a migration assessment for SQL Servers located anywhere:
- Your data center
- Edge site locations, such as retail stores
- Public cloud or hosting provider
The assessment is available for any instance of SQL Server enabled by Azure Arc.
Note
As a preview feature, the technology presented in this article is subject to Supplemental Terms of Use for Microsoft Azure Previews.
The latest updates are available in the release notes for SQL Server enabled by Azure Arc.
SQL Server migration assessment features
Azure SQL readiness assessment: Evaluate and measure the readiness of SQL Servers for migration to Azure SQL. This process
- Discovers and assesses the SQL Server instance and databases
- Pinpoints SQL Server workloads that are ready for migration
- Identifies potential compatibility issues with the target environment
- Assesses migration risks
- Provides recommendations to mitigate these risks
Azure SQL size recommendations: Provides best-fit recommendations, including the service tier and right-sizing based on performance history.
Prerequisites
To assess SQL Server, the SQL Server instance needs to:
Run on Windows-based SQL Server instance is connected to Azure. Follow the instructions at Automatically connect SQL Server machines to Azure Arc.
Have Azure Extension for SQL Server (
WindowsAgent.SqlServer
) version 1.1.2594.118 or later.Learn how to check the Azure Extension for SQL Server version and update to the latest.
The server has connectivity to telemetry.{region}.arcdataservices.com (for more information, see Network Requirements )
To view the assessment reports in Azure portal, you must be assigned an Azure role with the action
Microsoft.AzureArcData/sqlServerInstances/getTelemetry/
assigned. For convenience, you can use the built-in role Azure Hybrid Database Administrator - Read Only Service Role, which includes this action. For more information, review Learn more about Azure built-in roles.
Permissions
The Azure SQL extension for SQL Server performs the assessment data collection by default under the service account, NT AUTHORITY\SYSTEM. However, you can configure the agent extension service to run with an account that least privilege.
View migration assessment results
Sign into the Azure portal and go to your SQL Server enabled by Azure Arc
Open your SQL Server resource and select Assessments (preview) under Migration folder in the left pane.
The Last assessment time indicates when the assessment was started. To trigger an assessment immediately, select Run assessment.
Review readiness
The assessment indicates the different migration strategies that you can consider for your SQL Server deployments:
- Azure SQL managed instances
- SQL Server on Azure virtual machines
- Azure SQL databases
Review the readiness for target deployment types and the Azure SQL size recommendation. The readiness is based on the performance evaluation for the SQL Server instances and databases that are marked ready or ready with conditions.
Ready: The SQL Server instance or database is ready to be migrated to the specific Azure SQL target deployment option without any migration blockers. Should there be any warnings, address these issues using the provided remediation guidance.
Not ready: The assessment couldn't find a configuration to meet the compatibility, configuration, and performance characteristics on Azure Virtual Machine, Azure SQL Managed Instance, or Azure SQL Database. Select the hyperlink to review the recommendation to make the SQL Server instance/databases ready for the desired target deployment type.
Unknown: Azure Migrate can't assess readiness. This result can happen because the discovery is in progress or there are issues during discovery that need to be fixed. Check the notifications pane. If the issue persists, contact Microsoft support.
Review confidence rating
The confidence rating is a scale from one star (lowest) to five stars (highest). The confidence rating is projected to reach its peak (five stars) approximately after 30 days of continuous data collection. It should increase by one star for each week of data collection. The confidence rating helps you estimate the reliability of size recommendations in the assessment. The value is based on the availability of the performance/utilization data points needed to compute the assessment for all the assessed SQL instances and databases. Confidence ratings are as follows:
Data point availability | Confidence rating |
---|---|
0%-20% | 1 star |
21%-40% | 2 stars |
41%-60% | 3 stars |
61%-80% | 4 stars |
81%-100% | 5 stars |
Performance-based Azure SQL configuration (SKU size) calculation
The assessment aggregates all the configuration and performance data and tries to find the best match across various Azure SQL service tiers and configurations and picks a configuration that can match or exceed the SQL instance performance requirements, optimizing the cost.
SQL Server extension for Azure collects performance data for compute settings with these steps
The assessment collects a performance data sample point every 30 seconds.
Aggregates the sample data points collected every 30 seconds over 10 minutes. To create the data point, the size assessment selects the peak values from all samples. It gets the max, mean and variance for performance each counter.
We store all the 10-minute data points for the last month.
The assessment identifies the appropriate data point to use for right-sizing. Identification is based on the 95% percentile values for performance history.
For example, if the performance history is one week, the assessment sorts the 10-minute sample points for the last week. It sorts them in ascending order and picks the 95th percentile value for right-sizing. The 95th percentile value makes sure you ignore any outliers.
The high level metrics collected to decide the optimal Azure SQL target include.
The extension log file is at:
C:\ProgramData\GuestConfig\extension_logs\Microsoft.AzureData.WindowsAgent.SqlServer\
The log file name depends on the version Azure Extension for SQL Server, for the latest version of Azure Extension for SQL Server, the log file is:
unifiedagent.log
For extension version
1.1.24724.69
and earlier, the log file is:ExtensionLog_0.log
Run migration assessment
You can trigger a fresh assessment at any time. Select Run Assessment.
After the new assessment is complete, it replaces the last successful assessment. Scheduled migration assessments continue on schedule every Sunday at 11:00 PM (23:00) according to the local time on the SQL Server machine.
Disable migration assessment
The SQL Server migration assessment automatically gets generated for every SQL Server enabled by Arc. You can disable the assessment by using, Disable option on the top menu bar.
Re-enable migration assessment
Use Enable Assessment button to re-enable the SQL Server migration assessment.
Limitations
- SQL Server migration assessment is currently limited to SQL Server running on Windows machines, doesn't apply to SQL on Linux machines.
- SQL Server running on Windows Server 2012 and older versions aren't supported.
- SQL Server version must be 2012 or above.
- Failover cluster instances (FCI) aren't supported at this time.
Known issues
When the xp_commandShell
is enabled and utilized, it's recorded as a warning for SQL Managed Instance. This issue is considered a migration blocker. It disrupts the functionality of the object that specifically leverages xp_commandShell
. Use the remediation guidance provided in the assessment to mitigate the issue.
Troubleshooting
Contact Microsoft support if you run into any of the issues below.
- The assessment reports don't appear on the portal even after the scheduled time.
- Confidence rating doesn't increase after one week of data gathering. The confidence should increase after the first week.