Scraping 90+ GB from the Moodle application and packing that to a single file is something. Still a 8 vCPU, 32 GB RAM VM must be able to do that without maxing out - when it is idle. I would thoroughly investigate whether another party, or the system administrator of the host are involved. 2 am is a time when a machine should be idle. But if two people think the same, you know what happens. ;)
It could also explain why not everyday. It happens only when the two jobs overlap.
In fact, single thread processes don't max out the CPU, because waiting for the I/O system automatically throttle the process. My feeling.
To go deeper other than ask everybody who is involved, you need a good monitoring system which take a record, graphs, of many matrices in the machine. See for example How do you monitor your Moodle server? General information are in the forum documentation - Performance and Performance FAQ.
It could also explain why not everyday. It happens only when the two jobs overlap.
In fact, single thread processes don't max out the CPU, because waiting for the I/O system automatically throttle the process. My feeling.
To go deeper other than ask everybody who is involved, you need a good monitoring system which take a record, graphs, of many matrices in the machine. See for example How do you monitor your Moodle server? General information are in the forum documentation - Performance and Performance FAQ.