Administering Relational Databases on Microsoft Azure — Question 48

You have five instances of SQL Server on Azure Virtual Machines.

You need to monitor Microsoft SQL Server performance for all the instances by consolidating metrics into a single graphic display. The solution must minimize administrative effort.

What should you use?

Answer options

• A. Azure Monitor
• B. Log Analytics
• C. SQL Insights
• D. Azure SQL Analytics

Correct answer: A

Explanation

The correct answer is Azure Monitor, as it provides a comprehensive view of performance metrics across multiple SQL Server instances in a single dashboard, streamlining monitoring efforts. Log Analytics is more focused on querying and analyzing logs, while SQL Insights and Azure SQL Analytics are tailored for specific SQL performance metrics and may not provide the consolidated overview required.