Microsoft DP-300 Exam Sample Questions / Microsoft Administering Relational Databases on Azure (DP-300)

Useful DMVs in cases above that can help us identify bottlenecks with I/O are:

• sys.dm_os_wait_stats
• sys.dm_os_waiting_tasks
• sys.dm_io_virtual_file_stats