Many of the following sections suggest that you change configuration parameters to reduce lock contention.
Use sp_object_stats or sp_sysmon to determine if lock contention is a problem, and then use it 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” on page 269 in Performance and Tuning: Monitoring and Analyzing for more information about using sp_sysmon to view lock contention.
If lock contention is a problem, you can use Adaptive Server Monitor to pinpoint locking problems by checking locks per object.
