Using the Database Migration Assistant - Getting questionable results.

• Fletch

  SSC Enthusiast

  Points: 176

  More actions

  August 13, 2024 at 1:51 am

  #4444325

  Hello,

  Firstly, apologies if I have posted in the wrong spot, I could not find a 'Migration' forum here. Happy to move it elsewhere if need be.

  I am using the Database Migration Assistant to recommend an Azure SQL Managed Instance SKU for an on-premises SQL Server 2017 instance. I ran the assessment over 3-4 weeks, but the results I either do not understand or are questionable. One of the results I got was:

  Database Name: N/A Whole Instance

  Platform / Service Tier: Azure SQL Managed Instance – Gen5- General Purpose

  Compute Sizing: 8 vCores

  Storage Sizing: 4512  GB

  Based on the performance counters for your CPU, memory, storage, IOPS, and IO latency that were collected between 6/13/2024 6:56:00 AM and 7/5/2024 4:38:43 AM, the optimal AzureSqlManagedInstance SKU that we recommend you migrate to is: SQLMI_GP_Gen5_8. This SKU satisfies 0% of your current utilization needs with a 1.02x buffer on your current CPU usage.

  What does it mean when it says:

  'This SKU satisfies 0% of your current utilization needs with a 1.02x buffer on your current CPU usage.'

  If it satisfies 0% of my current utilization needs, why did it not recommend a different tier or SKU that does? Or am I misinterpreting it?

  Thank you for reading and for any help or recommendations.

   

• Grant Fritchey

  SSC Guru

  Points: 399058

  More actions

  August 13, 2024 at 12:07 pm

  #4444461

  I've never used it, especially not in anger, so I've got nothing. However, I've reached out to see if I can get someone over here to help out.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning