We are using Azure hyperscale DB Gen5 DB to store lots of data.
We have a stored procedure that runs an ETL and transfers data from one table to another.
We’re noticing that when having 2/4 vCores, even if the cpu_percentage metric is pretty low (around 30-40%), we still have delays in our processing (counted as the time of the oldest record in the table we’re moving FROM, which should always be very low).
When we upscale to 6 vCores, processing starts working fine.
Any ideas on why that could be, and if there is any other metric we can use to better estimate the need for upscaling ?