What is the sys.dm_tran_locks DMV?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the sys.dm_tran_locks DMV?
Rating:
The sys.dm_tran_locks DMV (Dynamic Management View) is used to get information about currently active lock manager resources. Each row represents the locks that are either already granted or waiting to be granted.
The columns of the DMV are divided into the following two groups:
- Resources
- Request
Rating:
Was this information helpful?
Other articles
- What is a job?
- What is SQL Profiler?
- What is the DISTINCT clause?
- What is Replication Monitor?
- What is Disk Management?