The deadlocks refers to a situation in which multiple process or a threads are unable to proceed as they are waiting for each other(s) to release resource upon which they need to continue. It is an undesirable situation where multiple processes or threads are unable to continue due to circular resource contention. In the deadlock stats window, you can see the following details which are listed below:

• Timestamp: This refers to a data element that records the date and time when a specific event or SQL query occurred within a database management system (DBMS). You can see the date and time in the following format MM/DD/YY and HH:MM:SS.
• Date: This refers to a specific date type used to store data values in a database. The "Date" data type is commonly used to represent calendar dates, including the year, month, and day without the associated time component.
• Query: This refers to a command or statement within a Structured Query Language (SQL) that is used to interact with a relational database.
• Application Name: This refers to a parameter or attribute that is typically associated with a database connection or session.
• Host Name: This refers to a name or network identifier to the device from which a specific database session originates.
• Process ID: This refers to a unique identifier assigned to a database process or connection with a database management system (DBMS) which tracks and manages individual database sessions and processes.
• Isolation Level: This refers to the concept used in database management system (DBMS) to define the degree of isolation between concurrent transactions or a database session.
• Batch Completed Time: This refers to the timestamp when a batch job which consist of one or more SQL statements has finished its execution.
• Batch Start Time: This refers to the timestamp when a batch job begins its execution. This information is crucial for monitoring, scheduling, auditing, troubleshooting, and ensuring the successful execution of batch processes within a database system.
• Login Name: This refers to the identifier associated with the user or application that is authenticated and currently connected to a SQL database.
• SPID(Session Process ID): This refers to a unique identifier assigned to each active database session or process within a database management system.
• Status: This refers to the current status of the session i.e.: Sleeping and Active.

Table Operations

There are following operation which you can perform on the DB Query Stats table which are listed below:

• Search: You can perform search operation in the table by providing the query values in the Search in table column icon. You can search by providing timestamp, elapsed time, wait time, worker time etc in the search table column.
• Download : This will download the DB query stats report in the CSV file format in your local.
• Toggle Columns : On clicking this icon, you will be able to show or hide a column from the DB query stats window.
• Toggle Filter : On clicking this icon, you can apply search operation on columns in the DB query stats window.
• You can also see the applied time filter on the right side of the window.
• If you want to disable the analysis mode, then you have to click on the Analysis Mode Toggle button
• If you want to disable the real time mode, then you have to click on the Real Time Mode Toggle button.