Add RAM to the VM. That should be easy. I have no idea what Cloudberry needs, but I'd go to 32GB and preferably 64GB, for the VM with SQL Server getting 24GB+
You might be able to get some idea from Cloudberry of what they need.