Lock management reporting

Output from sp_sysmon gives 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”.

Use Adaptive Server Monitor to pinpoint locking problems.