You are a database administrator for AIOTestKing.com. Users report that a SQL Server 2005 application stops responding for several seconds at a time during the day. This problem occurs randomly throughout the day and affects many users at once. When the problem occurs, you notice that CPU utilization and disk utilization on the SQL Server 2005 computer are low, but that the network is operating normally. You need to examine additional information relevant to the problem. What should you do?
A.
Examine the sys.dm_tran_locks dynamic management view (DMV).
B.
Examine the total number of lock requests on the SQL Server 2005 computer.
C.
Examine the output of the DBCC SHOWCONTIG command.
D.
Examine the total number of index and table scans on the SQL Server 2005 computer.
E.
Examine the output of the DBCC SQLPERF(IOSTATS) command.
Explanation:
sys.dm_tran_locks returns information about currently active lock manager resources. Each row represents a currently active request to the lock manager for a lock that has been granted or is waiting to be granted.The columns in the result set are divided into two main groups-resource and request. The resource group describes the resource on which the lock request is being made, and the request group describes the lock request.