QuestionQ94

VerifiedMonitor, configure, and optimize database resources

You have an Azure subscription.

You need to deploy an SQL Server instance on Azure Virtual Machines. The solution must meet these requirements:

  • Custom performance configuration, including IOPS, capacity, and throughout, must be supported.
  • Costs must be minimized.

Which disk type should be included in the solution?

Explanation

Premium SSD v2 lets capacity, IOPS, and throughput be configured independently, so the disk can be sized and provisioned for the SQL Server workload without paying for unnecessary bundled performance. Microsoft identifies Premium SSD v2 as suitable for SQL Server workloads and notes that its independent configuration provides flexibility and reduced costs.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!