Hello Carl Danielsson,
Thanks for your question
You can take a look at the VM series https://azure.microsoft.com/en-gb/pricing/details/virtual-machines/series/
You can check Compute-Optimized VMs in the Fsv2-series and Memory-Optimized VMs in the E-series with High memory-to-vCPU ratio as they should suit your workload.
You can mark it 'Accept Answer' and 'Upvote' if this helped you
Regards,
Abiola