You troubleshoot a SQL Server 2008 instance.
You suspect that an application uses an inefficient locking strategy and causes concurrency
problems.
You need to identify the following:
-The sessions that wait for a resource -The resource needed -The sessions that block the
resource
Which dynamic management view should you use?
A.
sys.dm_os_waiting_tasks
B.
sys.dm_os_wait_stats
C.
sys.dm_tran_active_transactions
D.
sys.dm_exec_requests