Select from following answers:
Show Correct Answer
- We can use SQL Profiler to capture lock and blocking information.
- 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
- We can use the Activity Monitor in SSMS to see information on blocking processes.
- We can use the sys.dm_tran_locks dynamic management view to gather information on locks being held by transactions.
- All Above
Asked In: Many Interviews |