Chat now with support
Chat with Support

Spotlight on SAP ASE 2.12 - User Guide

Spotlight on SAP ASE
Background Information Desktop Features Connect to SAP ASE Spotlight® on SAP ASE Drilldowns Spotlight® on SAP ASE Alarms Glossary
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

Dead Locks grid

The Dead Locks grid shows a listing of deadlocked objects and related information on the processes involved.

Deadlocks occur more frequently as the lock contention increases on a server. This is particularly true with long-running transactions that run concurrently in the same database. This contention decreases concurrency.

There are several methods for reducing lock contention, such as changing the locking scheme, avoiding table locks, and not holding shared locks.

Additionally, ensure that the application acquires locks on objects in the same order. Well designed applications can minimize deadlocks by always acquiring locks in the same order. Updates to multiple tables should always be performed in the same order.

The following table describes the columns on this grid:

Column

Description

Time Resolved

Time when the deadlock was resolved

Database Name

Name of the database for the deadlocked object

Object Name

Object name of the deadlocked object

Victim KPID

KPID of the victim process for the deadlock

Held KPID

KPID of the process holding the lock

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating