You have an Azure SQL managed instance named SQLMI1 that has the following settings:
• vCores: 4
• Service tier: General Purpose
• Hardware generation: Standard-series (Gen5)
You discover that memory pressure on SQLMI1 is high.
You need to reduce the memory pressure on SQLMI1. The solution must minimize costs.
What should to do?
Given that the primary concern is to reduce memory pressure while minimizing costs, increasing the number of vCores from 4 to 8 is the most appropriate solution. In Azure SQL Managed Instance, vCores are directly tied to the amount of available memory. Doubling the vCores from 4 to 8 will increase the available memory, thus alleviating memory pressure. This solution is cost-effective compared to changing to a higher service tier or switching to a different hardware generation.
Answer should be: C. Change Hardware generation to Premium-series. Business critical tier would be too expensive compared to changing the hardware type. Also, changing the number of vcores would not resolve any memory-related issues.
Sorry forgot one last thing on hardware type: standard series comes with less memory compared to premium-series. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql
Memory for StandardSeries(Gen5) is 5.1 GB per vCore . Doubling the cores doubles the memory too.
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql I think the answer is correct
I think same, cheapest option will be change to vCores to 8, then changing hardware generation then Service Tier to BC.
The correct answer is (A). The Query Store option is a cost-effective way to reduce memory pressure on a managed Azure SQL instance. The Query Store stores temporary data used by queries in the cloud, reducing the memory requirements of the managed Azure SQL instance.
I think it should be A.