Good afternoon Bruno,
To change the MIN_CPU value for a database inside an Azure SQL Database pool, you can use the ALTER DATABASE SCOPED CONFIGURATION statement. This statement allows you to configure various settings for individual databases within the pool, including the MIN_CPU_PERCENT value.
Here's an example of how you can set the MIN_CPU_PERCENT value for a specific database within the pool:
-- Connect to the specific database you want to configure
-- Set the MIN_CPU_PERCENT value
ALTER DATABASE SCOPED CONFIGURATION SET MIN_CPU_PERCENT = 10; -- Replace 10 with the desired minimum CPU percentage
-- Verify the configuration change
SELECT * FROM SYS.DM_USER_DB_RESOURCE_GOVERNANCE WHERE DATABASE_ID = DB_ID();
In the above example, I've set the MIN_CPU_PERCENT value to 10 as an example. You can replace it with the desired minimum CPU percentage for your database. Keep in mind that the value must be within the range defined by the maximum and minimum values specified at the pool level.
After executing the ALTER DATABASE SCOPED CONFIGURATION statement, you can verify the configuration change by querying the
SYS.DM_USER_DB_RESOURCE_GOVERNANCE view, as you did before, to ensure that the MIN_CPU_PERCENT has been set to the desired value for the specific database.
By setting the MIN_CPU_PERCENT value, you can ensure that a certain percentage of the CPU resources will be guaranteed for a particular database, preventing excessive resource contention and potential slowdowns in the system
I hope this helps with your query?