You have an SAP production landscape in Azure. You have a SQL server instance on an Azure virtual machine named SQL1 that hosts an SAP database. You discover that the CPU resources on SQL1 are…

Question

Options

• AApply an Azure reservation to SQL1.
• BChange SQL1 to a constrained vCPU size.
• CChange SQL1 to a compute optimized size.
• DChange SQL1 to a memory optimized size.

• A
  6% (2)
• B
  83% (30)
• C
  8% (3)
• D
  3% (1)

Explanation

Azure offers constrained vCPU sizes for virtual machines, which can be beneficial for SQL Server workloads, especially when you need to balance cost and performance. These sizes have a reduced number of active vCPUs compared to the base size, but the memory, storage, and I/O remain the same. This allows you to pay for fewer vCPUs while still utilizing the higher memory- to-vCore ratios that are often beneficial for SQL Server. By using constrained vCPU sizes, you can reduce your SQL Server licensing costs while still benefiting from the higher memory-to-vCore ratios that are often needed for SQL Server https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance- guidelines-best-practices-vm-size?view=azuresql

No community discussion yet for this question.