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.