CODEWITHSUNDEEP
databaseazurememory-managementazure-sql-databaseazure-elasticpool
CloudComputeSaver
CloudComputeSaver

Reputation: 1

Optimizing Azure SQL Elastic Pools with high memory but low CPU

I have a couple General Purpose SQL elastic pools that are configured at 8 vCores. The CPU of these pools peak no higher than 30% which inclines me to want to reconfigure the elastic pool (to maybe 4 vCores). However, the SQL instance memory percent of these pools have peaked as high as 80%. Is there a way for me to optimize these pools? Would increasing allocated storage to the pool help at all?

I have thought about sizing the number of vCores down but I don't want to do this if it there will not be enough memory to handle this.

Upvotes: 0

Views: 449

Answers (1)

Alberto Morillo
Alberto Morillo

Reputation: 15608

Unfortunately, by design the available RAM for your Azure SQL Databases will be always proportional (a variable that depends on) to the number of vCores of the tier. It is the same for vCore and DTU models, and it is also the same for Azure SQL Managed Instance. You can verify that by querying the sys.dm_user_db_resource_governance dynamic management view when you scale up or down a database. There is no way to avoid that.

SELECT * FROM sys.dm_user_db_resource_governance

Upvotes: 0

Related Questions