Azure Database Scaling Doubt

  dev env - 8 core db QA env - 8 core db prod env - 16 core db in start long running job, or high db consuming task the efficiency is going down currently we have 32 core db doubling the cost ...