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
Explanation:
http://msdn.microsoft.com/en-us/library/azure/dn306639.aspx