Microsoft
70-432 · Question #183
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…
The correct answer is A. sys.dm_os_waiting_tasks. See the full explanation below for the reasoning.
Question
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?
Options
- Asys.dm_os_waiting_tasks
- Bsys.dm_os_wait_stats
- Csys.dm_tran_active_transactions
- Dsys.dm_exec_requests
How the community answered
(37 responses)- A81% (30)
- B11% (4)
- C3% (1)
- D5% (2)
Community Discussion
No community discussion yet for this question.