You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on
Windows Server 2012 servers running SQL Server 2012.
One server is named ABC-SQL1. You want to gather information about all the waits
encountered on ABC-SQL1 by threads that execute.
How can you generate a report to display the most frequent wait types that occur on ABC

SQL1?

A.
By viewing the SQL Server Error Logs.

B.
By using a dynamic management view querying sys.dm_exec_query_stats.

C.
By using a dynamic management view querying sys.dm_os_waiting_tasks.

D.
By using a dynamic management view querying sys.dm_os_wait_stats.

Explanation: