QuestionQ96

VerifiedMonitor, configure, and optimize database resources

You have an Azure SQL database named DB1 in the General Purpose service tier.

The performance metrics for DB1 are displayed in the following exhibit.

Question Image

You need to reduce the Log IO percentage. The solution must minimize costs.

What should you do?

Explanation

A 100% Log IO percentage means transaction-log writes are consuming the maximum log-write throughput available to the database. In the General Purpose vCore tier, maximum log rate rises with the configured number of vCores, so increasing vCores raises the log I/O limit without the higher cost of moving to the Business Critical tier.

Learn more

Community Discussion

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