Process locks

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"