Lock management reporting

Output from sp_sysmon provides statistics on locking and deadlocks discussed in this chapter.

Use the statistics to determine whether the Adaptive Server system is experiencing performance problems due to lock contention.

For more information about sp_sysmon and lock statistics, see “Lock management” in Performance and Tuning Series: Monitoring Adaptive Serve with sp_sysmon.

Use the monitoring tables to pinpoint locking problems. See the Performance and Tuning Series: Monitoring Tables.