@xzyzzz ,
For processing 20GB of data and running numerous queries, a good starting point would be using a general-purpose virtual machine with a memory-to-vCore ratio of 8, recommended for production workloads. The minimum recommended configuration for a general-purpose VM running SQL Server is 4 vCPU and 32 GiB of memory. The Ddsv5-series virtual machines support premium storage and premium storage caching and offer a fair combination of vCPU, memory, and temporary disk but with smaller memory-to-vCore support. The D8ds_v5, which has 8 vCores and 32 GiBs of memory, is recommended as the starter virtual machine in this series.
If the above answer doesn't help. Can you please elaborate your question so that community members can help you. Thanks.
References:
- VM size: Performance best practices for SQL Server on Azure VMs - General Purpose
- Storage: Performance best practices for SQL Server on Azure VMs - Overview
Note: Used Microsoft Q&A AI Assist to generate the answer.