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?

A. extended events to monitor the Processor:%Privileged Time of the virtual machine and SQL Server Agentalerts to notify the operator by sending an email message
B. Azure Diagnostics for the logs on the virtual machine and a rule in Management Services to send you an email message when the CPU usage is more than 80 percent
C. extended events to monitor the Processor:%User Time of the virtual machine and SQL Server Agent alerts to notify the operator by sending an email message
D. an alert rule in the Azure portal to send you an email message when the CPU usage is more than 80 percent for five consecutive minutes
  Discussion forum

Question
0

Leave an answer