This view shows the count of lock requests for every process in the Adaptive Server that generated lock requests during the most recent sample interval.
hs_create_view process_lock, "Login Name", "Value for Sample", "Process ID", "Value for Sample", "Kernel Process ID", "Value for Sample", "Lock Count", "Value for Sample"