The locks refers to the mechanism used in a database management system (DBMS) to control access to resource (such as: tables, rows etc) to ensure data consistency and integrity in a multi-user environment. In the locks window, you can see the following details which are listed below:

• Action: In action, you can perform drill-down operation for each and every row by clicking on the icon. By performing this action, you can navigate to the respective child processes of a particular session.
• Timestamp: In action, you can perform drill-down operation for each and every row by clicking on the icon. By performing this action, you can navigate to the respective child processes of a particular session.
• SPID(Session Process ID): This refers to a unique identifier assigned to each active database session or process within a database management system.
• DB Name: This refers to the name of the specific database within a database management system (DBMS) that is currently being accessed by a particular session.
• Request Count: This refers to the number of SQL request that a specific session has issued to the database during its lifetime.
• Resource Type: This refers to the specific type of database resource or object that are involved in a blocking scenario.
• Request Mode: This refers to the mode in which a session is requesting access to a database resource.
• Request Status: This refers to the current status of a specific request initiated by a session in a database management system.
• Login Name: This refers to the identifier associated with the user or application that is authenticated and currently connected to a SQL database.

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.

Note: In locks you cannot modify tha same record by two different connections whereas, in latches it ensures that the record resides in a proper data page for further reading and writing operation.