How much memory Cloudberry needs when two plans are running simultaneously? Just to clarify are both plans SQL Server plans? - Yes
One is the daily full backup and the other is the recurring transaction log backup? -Yes
One plan is recurring transaction logs every 5 minutes and full at night for two databases, the other plan is nightly "full" for system and other user databases.
Where are your backups eventually going - cloud or local network? Cloud, AWS s3 bucket
What are your Thread Count and Chunk Size settings in Settings - Advanced? No
How much memory is available on the server (available, not total memory)
This is a dedicated SQL server with no other business processes running on it (except for cloudberry). Microsoft recommends to let SQL manage memory. It constantly queries available RAM and adjust required memory accordingly. I used to leave 1GB for OS in older SQL Server versions but this is not the case anymore. I rather limit cloudberry than SQL Server, but if there is no way around it please advise how much Cloudberry needs and I limit SQL Server too.
https://docs.microsoft.com/en-us/sql/relational-databases/memory-management-architecture-guide?view=sql-server-ver15
Thank you