DB queries report provides the details on the database query. To view the database query results, click the DB Requests link on the Drill-Down Queries page or clicks the DB Call Count link on the Flowpath window (for a particular flowpath instance). The Database query report is displayed. This report display details, such as DB query, query count, error count, minimum count, maximum count, minimum time, maximum time, and average time (in ms) taken by the query. It also displays tier, server, and instance. On clicking the query name, the complete query is displayed in the Query text area.

DB Stats

DB stats refers to the collection and analysis of various statistical information related to the database's performance, usage, and health. In DB stats, you have the following fields which are listed below:

• Query: This is the database query request created by the application. A database query is a request to access data from a database to manipulate it or retrieve it.
• First Query Time: The time taken when the first query was run, when it has to load from disk.
• Last Query Time: The time taken when you have last run the query, after the first query subsequently DB uses memory, which is much faster than disk.
• Query Count: Represents the count of times the query has been executed.
• Error Count: The total number of times the query has encountered an error response.
• Min (ms): The minimum time taken by the query to get response from the DB.
• Max (ms): The maximum time taken by the query to get response from the DB.
• Average (ms): The average time taken by the query to get response from the DB.
• Execution Time (ms): The total time taken by the query to be executed.
• SQL Index: This is a database functionality that expedites data retrieval by creating a sorted representation of selected columns. SQL indexing significantly enhances search and filtering operations, which leads to faster query performance.

Note: You can also see the details for the DB queries stats in a graphical representation alongside the DB query table. By default, it will show you Top 5 DB Queries.

Query

In query, you can see the DB query name along with its detailed query structure.

Global Action Items

There are the following actions that you can perform in the DB Query window:

• Toggle Column: You can Show/Hidea column by clicking on the Toggle Column  in the table.
• Column Filter: You can perform a search operation on the column by clicking on the Column Filter in the table. You can search a column by DB Query Name, Min, Max values, etc.
• Search: You can search a particular DB Query namefrom the list on the DB Query table. To perform the search operation, you have to provide the DB Query name on the Search 

Note: You can also download the DB Query Stats Report in the following three formats:

• PDF: To download the DB query stats report in PDFformat, you have to click on the Download PDF Report icon.
• Word: To download the DB query stats report in Wordformat, you have to click on the Download Word Report  icon.
• Excel: To download the DB query stats report in Excelformat, you have to click on the Download Excel Report  icon.

You can also see the information related to the Data Center Name, Tier Name, Server Name, Instance Name, BT Name, BT Type, and also the time filter applied on the top of the DB Query Window.