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.
