How much memory Cloudberry needs when two plans are running simultaneously? Just to clarify are both plans SQL Server plans? One is the daily full backup and the other is the recurring transaction log backup? SQL Server allows running full and tlog backups at the same time - this has not been an issue since SQL Server 2000.
How do you have the plans set up? You say you are using two different plans, but I do not see a way to configure a plan to only perform t-log backups in our product - unless I'm just missing that config option. Please describe how you set your plans up. Usually, you would use a single SQL Server plan with Full, Differential (optional), and T-Log backups all defined and scheduled within that single plan.
- Where are your backups eventually going - cloud or local network?
- What are your Thread Count and Chunk Size settings in Settings - Advanced?
- How much memory is available on the server (available, not total memory) - I'm asking because SQL Server can be accidentally set up to use all available memory if it needs it leaving little memory for other processes. Check Management Studio server properties - Memory - Maximum Server Memory (It should not be set to 0 or too high as to leave little memory for other server processes). I realize SQL Server will release memory when needed, but not all applications work this way and some may not see the memory released