Skip to main content

Lock Tree & Dead Lock

You can analyze the trend of locks during the day. The session that caused a lock (Lock Holder) and the session waiting for a lock (Lock Waiter) can be checked through a tree structure. Through these functions, you can analyze queries by checking the relationship between holders and waiters for locks that occurred at specific points.

Lock tree

Home > Select Project > Analysis > Lock Tree

It provides the time series chart and lock tree for the locks occurred during the day. From the point where a lock first occurred, the structure of holders and waiters is displayed in a tree form. You can check the rock tree over time.

Basic screen guide

Lock tree

Select the desired date, time, and instance to view in number 1 Time and number 2 Instance. If a lock occurs at the set time, the searched data appears in Lock Wait Sessions and the Lock Tree table at the bottom of the screen.

  • You can see the data for up to two weeks within a chart. If you click a specific time in the graph chart, you can check the lock information for the selected time in the table at the bottom of the screen. If you select the button in seconds, you can view the lock information in 5-second increments.


    Through the tags on the upper right of the Lock Wait Sessions chart, you can see the units to view.

  • As you continuously drag (drill down) a specific time zone on the graph chart, you can see the charts and lock trees for detailed time zones.

  • You can see the data in 5-second increments by dragging within 3 hours on the chart. However, the data in 5-second increments can only be viewed within the most recent month. The data earlier than one month can only be viewed as 5-minute summary data. For example, you can drag (drill down) lock tree data from 40 days ago for the 5-minute summary data, but you cannot see 5-second data.

Instance NameInstance Name
idConnection identifier
userSQL execution account
hostHostname that this thread is connected to.
dbDefault database name. If nothing, it is NULL.
commandRunning command type (Query/Sleep/Daemon, etc.)
timeExecution time of the current command (sec)
stateCurrent thread status (executing, updating, sending data, etc.)
queryRunning statement. It displays the literal value SQL separated from
query_paramLiteral value separated from query
typeThread type. FOREGROUND/BACKGROUND, etc.
connection_typeThe protocol used to establish a connection. TCP/IP, SSL/TLS

Dead lock

Home > Select Project > Analysis > Dead Lock

A deadlock occurs when multiple processes or transactions block each other from processing by locking database resources (tables or rows). Frequent deadlocks cause inconvenience to end users and reduce the service quality. In the Deadlock menu, you can see the time and related data when the deadlock occurred. This information can help you identify and solve problems in the application design.


You can check information about deadlocks that have occurred in the database.

  1. Set the time to search in Time.

  2. Select an instance name to view in instance.

  3. Select Search icon.

It provides deadlock information in the form of table.


You can select a lookup time (up to 3 weeks). Select the clock display area to query a random date and time. If you click the date and time text area, the selectable options for the date and time appear.