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: