Microsoft
70-432 · Question #183
70-432 Question #183: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #183. The question stem and answer options stay visible for context.
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
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.