Database locks must be logged using the Database Query Log (DBQL). This lock information can be accessed by querying the DBC.QrylockLogXMLV view.
- For more information on DBQL, see Tracking Query Behavior with Database Query Logging: Operational DBAs and BEGIN QUERY LOGGING.