Select from following answers:- 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
All of the above approaches are used to know the lock status of an instance of SQL Server
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator