Share via

How to specify SQL Server Managed Instance hardware type when moving from SQL-on-VM?

Jonathan Gibbs 40 Reputation points
2024-01-03T11:28:59.6166667+00:00

I'm looking into migrating a fairly small (8GB) database from 'SQL Server instance on a VM' to 'SQL Server Managed Instance', but struggling with defining the spec. My VM version is Standard B4ms, 4 vCPUs, 16 GiB RAM, and performance is fine. Can I move to 'Standard-series (Gen 5)', 'vCORE 4' and 'General purpose' without loss of performance, or do I need to get something more expensive?

The price leap is huge, so I don't want to if I don't need to!

Azure SQL Database
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments No comments

Answer accepted by question author

Luke Murray 11,601 Reputation points MVP
2024-01-04T07:44:13.96+00:00

Hi, Jonathan

Your best bet would be to utilise the Azure SQL Migration assistant against the databases you want to migrate to Azure. You can leave this running for a few days to calculate and read the database performance and then supply recommendations, based on performance.

Was this answer helpful?


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.