So, I have a 4gb database file now and I kicked off a backup. It took about 90 minutes to complete the backup. The temp file was about 1.4gb in size and the GZ file was 158mb.
During the entire process, bill.exe only consumed 19mb of system memory and 9mb of virtual memory. There is over 700mb of system memory free. Considering how slow CAM is, wouldn't it benefit from using more system memory? If I give it 2gb of system memory, will it actually use more? It doesn't seem like it based on this performance.
It seem like CAM is trying to manipulate 4gb of data with only 18mb of system memory - no wonder it is slow. Also, it actually performs very little disk IO while it is working on reports and other non-backup functions.
Is there a setting I can tweak to get it to use more memory to improve performance? Or am I missing something?