You are the database administrator for a SQL Server 2005 computer named AIOTestKing A.
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.
You need to find the user name of the user with the blocking connection. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.
Choose two.)
A.
Execute sp_who 56.
B.
Select from the sys.syslockinfo compatibility view and locate spid 55.
C.
Use the Activity Monitor in Microsoft SQL Management Studio and locate process 56.
D.
Use the Activity Monitor in Microsoft SQL Management Studio and locate process 55.
E.
Select from the sys.syslockinfo compatibility view and locate spid 56.
F.
Execute sp_who 55.
Explanation:
Explanation The sp_who provides information about current users and processes in an instance of the Microsoft SQL Server Database Engine. The information returned can be filtered to return only those processes that are not idle. Use the Activity Monitor component of Microsoft SQL Server Management Studio to get information about users connections to the Database Engine and the locks that they hold.