You have a Microsoft Azure virtual machine that hosts a Microsoft SQL Server database instance. Users report that during peak workloads, the database is slower than expected.
You query sys.dm_os_waiting_tasks and you discover that there are a high number of PAGEIOLATCH waits.
You need to receive an alert if the storage on the Azure virtual machine is throttled.
What should you use?
A. a SQL Server Agent alert
B. Microsoft System Center alerts for DeviceRaidPort0 in the system event log
C. Performance Monitor alerts
D. Azure portal alerts on the storage pool
E. Azure portal alerts on the virtual machine
