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 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” 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.