Azure Hyperscale - Memory

Question

I have an database on Azure Hyperscale.
Right now the configurations of Hyperscale are as follows:
(1) Gen5 16 VCore
(2) 80 GB memory

It seems memory is not sufficient for our workload, can i just increase memory keeping vcores as 16 ??

Answer 1

Hello @ScalabilityExperts-4248
based on the below article you cannot increase RAM only you should upgrade to a higher tier because it is computed tier Check this Post https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale-frequently-asked-questions-faq#can-i-provision-a-compute-replica-with-extra-ram-for-my-memory-intensive-workload
and for more Information About Azure Database Tiers Check this article https://mostafaelmasry.com/2020/06/25/azure-sql-database-tiers-options/
I hope my answer helps you and fit with your question

Mustafa EL-Masry
Independent SQL Server Consultant, DB Performance Tuning Specialist, AZURE, Technical Author
https://www.linkedin.com/in/mostafaelmasry/
https://mostafaelmasry.com/
http://www.sqlidol.com/
M| +966 54 399 0968