SQL Managed Instance Hardware mapping

Question

Hi Experts,

For SQL managed instance , the Gen5 hardware specifications mention :

CPU Intel® E5-2673 v4 (Broadwell) 2.3 GHz, Intel® SP-8160 (Skylake), and Intel® 8272CL (Cascade Lake) 2.5 GHz processors
Number of vCores
vCore=1 LP (hyper-thread) 4-80 vCores

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits#hardware-generation-characteristics

Can you please guide

1. Here LP refers to logical processors/hyper threads as these series generally have 2 threads for each vcore
2. Multiple Intel series are mentioned, which one do we refer to compare with the on-premise for migration
3. Is there any tool which can map the onpremise compute and storage requirement to managed instance

Thanks

Answer 1

LP means logical processor. However G4 hardware does not use hyperthreading hile on Gen5 it does. Please check this article about hardware considerations to better match your on-premise hardware to Managed Instance offerings.

Please use this resource to learn to create and compare a performance baseline when migrating your SQL Server databases to Azure SQL Managed Instance. This includes CPU benchmark.

About comparing storage subsystem take in consideration the Log write throughput and IOPS as explained here.

Finally, take in consideration Azure Managed instance resource limits.