Snowflake seems to have several interesting documentations on what should be taken into consideration when deciding the size of warehouse and how to improve performance of a warehouse (e.g. https://docs.snowflake.com/en/user-guide/warehouses-overview.html#warehouse-size).