nerdexam
Microsoft

70-473 · Question #35

You have several SQL Server instances on Microsoft Azure virtual machines. Periodically, one of the virtual machines runs more slowly than expected. The issue typically persists for up to 30 minutes.

The correct answer is D. an alert rule in the Azure portal to send you an email message when the CPU usage is more than. To automatically get notified about high CPU usage on Azure virtual machines with minimum administrative effort, you should configure an alert rule in the Azure portal.

Monitor and manage an Azure data platform solution

Question

You have several SQL Server instances on Microsoft Azure virtual machines. Periodically, one of the virtual machines runs more slowly than expected. The issue typically persists for up to 30 minutes. You investigate the issue and discover that when the issue occurs, there is high CPU usage on the virtual machines. You need to be notified automatically when the performance issue occurs. You want to achieve this goal by using the minimum amount of administrative effort. What should you configure?

Options

  • Aextended events to monitor the Processor:%Privileged Time of the virtual machine and SQL
  • BAzure Diagnostics for the logs on the virtual machine and a rule in Management Services to send
  • Cextended events to monitor the Processor:%User Time of the virtual machine and SQL Server
  • Dan alert rule in the Azure portal to send you an email message when the CPU usage is more than

How the community answered

(58 responses)
  • A
    12% (7)
  • B
    7% (4)
  • C
    3% (2)
  • D
    78% (45)

Why each option

To automatically get notified about high CPU usage on Azure virtual machines with minimum administrative effort, you should configure an alert rule in the Azure portal.

Aextended events to monitor the Processor:%Privileged Time of the virtual machine and SQL

Extended Events are a SQL Server feature designed primarily for database monitoring and are not the most efficient or lowest administrative effort method for general virtual machine CPU usage alerts with email notifications.

BAzure Diagnostics for the logs on the virtual machine and a rule in Management Services to send
Cextended events to monitor the Processor:%User Time of the virtual machine and SQL Server
Dan alert rule in the Azure portal to send you an email message when the CPU usage is more thanCorrect

Azure Monitor allows you to create metric alert rules that monitor the CPU usage of Azure Virtual Machines. You can easily configure an alert to send an email notification when the CPU usage exceeds a predefined threshold, providing an automated solution with minimal administrative overhead by leveraging native Azure capabilities.

Concept tested: Azure Monitor metric alerts for virtual machine CPU

Source: https://learn.microsoft.com/azure/azure-monitor/alerts/alert-to-monitor-vm-cpu

Topics

#Azure Monitoring#Alert rules#CPU utilization#Performance monitoring

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-473 Practice