11
After migration, you're ready to transform and optimize, making any changes
required for your applications to run smoothly and efficiently. You can use
Azure tools and services to perform tests, address performance or security
issues, and then retest to confirm improvements. You can also review new SQL
features available on the Azure platform and implement them, as appropriate.
Performance optimization
You can run performance validation queries against both the source and Azure
SQL Database Managed Instance databases, and then analyze and compare
the results. For example, you might want to change the database compatibility
level for query regressions. You can use Query Store as the optimal tool
for getting information about workload performance before and after this
change. You can also check for missing, duplicate, redundant, rarely used, and
completely unused indexes, and then resolve them using the Database Engine
Tuning Advisor and Dynamic Management Views (DMVs).
Pricing optimization
After migration, you can right-size your on-premises SQL workloads in Azure.
Azure SQL Database Managed Instance introduces a pricing model based on
vCores, which lets you select the right level of resources (storage and compute)
for your workloads by comparing vCores to physical cores on-premises.
Security optimization
It's easy to optimize security in Azure through Azure Active Directory
authentication at the database level (Figure 3). With the free Microsoft Azure
Active Directory Connect tool, you can synchronize your on-premises Active
Directory to Azure Active Directory and enable single sign-on with Windows
user credentials. Azure SQL Database Managed Instance also adheres to
compliance standards available in Azure SQL Server, so there isn't a lot of
administrative overhead.
Step 3: Optimize
How do I approach migration? Chapter 05
