Today, we encountered the following error while attempting to scale down the database from 8 vCores to 2 vCores: 'SLO 'Update' operation cannot succeed as the memory usage of 'XYZ-XXX-49b1-bb62-XXXXX' exceeds the quota.
This error message indicates that the memory usage of your Azure SQL Database surpasses the quota allocated for the chosen number of vCores. In Azure SQL Database, the memory configuration is linked to the vCore count.
When you scale down the database from 8 vCores to 2 vCores, the memory allocated to the database is reduced accordingly. However, if the current memory usage of your database remains high even after the scale-down, it might still surpass the quota for the new configuration.
To resolve this issue, you have a few options:
1. Review and optimize your database: Analyze the memory usage of your database and identify areas where you can optimize. This could involve optimizing queries, reducing unnecessary indexes, or reviewing the design of your database schema to minimize memory usage.
2. Trying to find a higher vCore configuration: Instead of scaling down to 2 vCores, you can consider scaling up to a higher vCore configuration that provides more memory.
Ensure to evaluate your resource utilization patterns and optimize the database to efficiently allocate resources and prevent quota exceedances.