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” on page 269 in the Performance and Tuning: Monitoring and Analyzing.
Use Adaptive Server Monitor to pinpoint locking problems.
