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?

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?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *