1. Science / Technology

Discovery and Assessment of SQL Server at Scale with Azure Migrate

Disclaimer: This is a user generated content submitted by a member of the WriteUpCafe Community. The views and writings here reflect that of the author and not of WriteUpCafe. If you have any complaints regarding this post kindly report it to us.

An organization’s successful cloud migration is heavily dependant on moving its on premises infrastructure to the cloud, and Azure Migrate greatly simplifies this process by allowing you to perform agentless discovery and readiness assessments of SQL server. This is an easy solution to discover your entire SQL ecosystem, and have a unified experience for assessments of your IaaS & PaaS assets.

Azure Migrate offers a complete repository of tools from Microsoft and partners for your migration needs. The latest release unifies three tools for server, database and web-app assessment to create a guided start-to-finish flow. You can now perform assessments for Azure SQL Managed Instances & Azure SQL Databases. Imminent releases are expected to support integrated assessment for Azure App Service too. With this release you can discover SQL Server and databases (running in VMware) and conduct analyses of their configuration and performance, as well as check application dependencies before migration.

Onboard Windows/Linux/SQL servers en masse

With Azure Migrate app for VMware you can conduce discovery, assessment, inventory and map application dependencies.

Using Azure Migrate you can deploy your on premises appliances or upgrade existing appliances to begin discovery of your SQL Server-instances/databases. The appliance also enables inventory of installed software and agentless dependency mapping.

Once you provide credentials—for authentication of domain non-domain and SQL—Azure Migrate will map credentials of your servers and databases.

For complete security your credentials ad encrypted and stored on your appliance in your datacenter itself and not shared with Microsoft.

Discovery and app dependencies

  • Azure Migract can model SQL server instances and databases, as well as SQLs running on the same server.
  • Discover up to six thousand databases with a single Azure Migrate appliance.
  • Performance data is updated every 30 seconds, giving you accurate recommendations
  • Supports discovery of SQL instances/databases on SQL Server 2008 to SQL Server 2019, and all versions in between. It also supports Developer/Enterprise/Express/Web editions
  • Discovery includes SQL server-version/edition, availability mode, count, size of user databases, & level of compatibility.
  • Agentless dependency also identifies application tiers and interdependent applications, giving you useful information when planing migration of inter-dependent servers

Assessment, right-sizing and cost optimization

Azure Migrate assessment includes assessment logic built by Microsoft’s SQL teams, beefed up to deliver at scale experiences for SQL Server. Its assessment support includes Azure infrastructure service and Azure VMware. 

You can tailor your assessments by scenario, region, Azure SQL deployment type, reserved capacity, service tier, and performance history.

The recommendations cover service tier and right-sizing based on performance history, as well as projected compute and storage costs. These are calculated on most cost effective Azure SQL deployment.

Beyond migration readiness data, you can also identify blockers and issues, so these can be addressed as required.

To help comparison and selection of the Azure options that work best your needs, you can also change assessment inputs and make multiple assessments using the same SQL instances and databases.

contact Teleglobal for a no-commitment consultancy on how you can leverage Azure Migrate to smoothen your cloud migration and enjoy higher productivity and lower costs



Welcome to WriteUpCafe Community

Join our community to engage with fellow bloggers and increase the visibility of your blog.
Join WriteUpCafe