Forum Discussion

manas0806's avatar
manas0806
Copper Contributor
Feb 14, 2024

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

by default azure gives us scale up and scale down but they only do on number of cores, in scale up azure just adds another system for example it adds more 32 core system over the present 32 core system whereas i have to be in 48 core when it is busy.

scale down means going one system below from 32 cores to 16 core, german morning and afternoon are busy, but in US afternoon and asian morning, it is very low usage, based on system value or time we can scale down core of the system.

 

could not find eaiser solution which could do that.