Which of the following options can be used for viewing lock status within your computer running SQL Server?

 Posted by Bandi on 9/30/2013 | Category: Sql Server Interview questions | Views: 1139 | Points: 40
Select from following answers:
  1. We can use SQL Profiler to capture lock and blocking information.
  2. We can use the System Monitor that is part of the performance console to capture statistics on lock wait times, locks per second, and so on
  3. We can use the Activity Monitor in SSMS to see information on blocking processes.
  4. We can use the sys.dm_tran_locks dynamic management view to gather information on locks being held by transactions.
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response