Using sp_sysmon and sp_object_stats

Many of the following sections suggest that you change configuration parameters to reduce lock contention.

Use sp_object_stats or sp_sysmon to determine whether lock contention is a problem. Then use the stored procedures to determine how tuning to reduce lock contention affects the system.

See “Identifying tables where concurrency is a problem” for information on using sp_object_stats.

See “Lock management” in Performance and Tuning Series: Monitoring Adaptive Server with sp_sysmon for more information about using sp_sysmon to view lock contention.

If lock contention is a problem, you can use Adaptive Server Monitor or the monitoring tables to pinpoint locking problems by checking locks per object.