QuestionQ102

VerifiedMonitor, configure, and optimize database resources

You are planning a solution that will use Azure SQL Database. Solution usage will peak from October 1 through January 1 each year.

During peak usage, the database will require:

  • 24 cores
  • 500 GB of storage
  • 124 GB of memory
  • More than 50,000 IOPS

During off-peak periods, the Azure SQL Database service tier will be set to Standard. Which service tier should you use during peak usage?

Explanation

The Business Critical service tier provides the required high-performance, low-latency architecture. Its provisioned-compute configuration can supply 24 cores, approximately 124 GB of memory, 500 GB of storage, and more than 50,000 IOPS. Premium is a DTU-based tier, whereas Business Critical exposes the required vCore-based resource capacity.

Learn more

Community Discussion

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