August 13, 2024 at 1:51 am
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.
August 13, 2024 at 12:07 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply