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 Monitor Server and the monitoring tables to pinpoint locking problems. For more information, see the Performance and Tuning Series: Monitoring Tables and the Monitor Server User Guide.
