Query Output

In the query output window, you can see the following details for an executed query which are listed below:

Status This refers to the current status of the execution of a SQL query which provides information about the progress and outcome of the query which is being executed such as: BACKGROUND.
DiskIO This refers to the measurement and monitoring of input/output (I/O) operations related to disk storage during the execution of SQL queries.
Command This refers to the type of the SQL command or statement which is being executed as a part of query such as: LOG WRITER.
LastBatch This refers to the date and time at which the last query batch was executed. This is displayed in the MM/YY and HH:MM:SS format.
DBName This refers to the name of the database on which the query was executed.
Login This refers to the username through which the database was logged in.
BlkBy This refers to the identifier of the session that is currently blocking the execution of a particular SQL query.
Program Name This refers to the descriptive identifier associated with the application or program that initiated a particular SQL query.
SPID This refers to the unique session number for the SQL agent job.
HostName This refers to the network host name form which a SQL query is initiated and sent to the SQL server for execution.
REQUESTEDID This refers to the amount of CPU processing time consumed by a specific SQL query during its execution.
CPUTime This refers to the amount of CPU processing time consumed by a specific SQL query during its execution.

Note In the query output window, you can perform the following operations which are listed below:

Search: You can perform search operation in the table by providing the name, value, value in use etc in the Search in table column icon.
Download : On clicking this icon, it will download the Query Output report in the CSV file format in your local.

Note In the configuration logs window, you can apply the analysis mode by clicking on the Enable Analysis Mode button.