Which is the correct answer?

You are the database administrator for a SQL Server 2008 computer named TESTDB. A user
reports that his query has been running for a very long time and is still running. You access the
sys.dm_tran_locks dynamic management view (DMV). The relevant results are shown in the
following table.exhibit Which is the correct answer?

You are the database administrator for a SQL Server 2008 computer named TESTDB. A user
reports that his query has been running for a very long time and is still running. You access the
sys.dm_tran_locks dynamic management view (DMV). The relevant results are shown in the
following table.

Which is the correct answer?

A.
Execute sp_who 55.

B.
Execute sp_who 56.

C.
Use the Activity Monitor in Microsoft SQL Management Studio and locate process 55.

D.
Select from the sys.syslockinfo compatibility view and locate spid 55.



Leave a Reply 0

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