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 click the DB Call Count link on the Flowpath window (for a particular flowpath instance). The Database query report is displayed. This report displays 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:

Note:

• 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: This is the time taken when the first query was run and when it is loaded from disk.
• Last Query Time: This is 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: This represents the count of times the query has been executed.
• Error Count: This is the total number of times the query has encountered an error response.
• Min (ms): This is the minimum time taken by the query to get a response from the DB.
• Max (ms): This is the maximum time taken by the query to get a response from the DB.
• Average (ms): This is the average time taken by the query to get a response from the DB.
• Execution Time (ms): This is 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.

Query

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

Global Action Items

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

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

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

• Word: To download the DB query stats report in Word format, you have to click on the Download Word Report icon.
• Excel: To download the DB query stats report in Excel format, you have to click on the Download Excel Report icon.
• PDF: To download the DB query stats report in PDF format, you have to click on the Download PDF 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 the time filter applied on the top of the DB Query Window.