Foglight for SQL Azure 5.5.8.6

Clicking the SQL Text row displays a page that allows viewing detailed information about the selected SQL statement. For details, see SQL Statement Details page on page 35.

Figure 1. Top SQL Statements Table

Table 6. Top SQL Statements Table
Column	Description
SQL Handle	Provides a unique identification of a SQL batch script.
SQL Text	The SQL text for the selected SQL statement.
Object Name	The name of the object owning the SQL; for example, view, procedure or function. This value can be Unavailable for SQL statements that are not object-owned, such as Ad-Hoc queries.
% CPU Workload	The relative share, in percentage, which the selected SQL statement occupies within the instance’s total CPU consumption.
Executions Started	The number of the selected SQL statement’s executions that started during the selected time range.
SQL % Hit Rate	The hit rate, in percentage, of the selected SQL Statement.
Elapsed Time	The total time consumed for carrying out the SQL statement executions.
CPU Time	The total CPU time consumed for carrying out the SQL statement executions.
Total I/O Operations	The total number of reads, both physical and logical, carried out by the selected SQL statement.

SQL Activity section

The SQL Activity section displays the workload and executions of the SQL statement that was selected in the Top SQL Statements table.

Figure 2. SQL Activity Section

•

Workload (Average Active Sessions)—displays the activity (system workload), plotted over the specified time range. This chart allows comparing the following metrics:

•

Overall CPU Workload—the workload incurred by the total top SQL statements displayed in the table above

•

Selected SQL CPU Workload—the average number of active sessions incurred by the selected SQL statement

•

Executions—displays the number of times the selected SQL statement was executed during the selected time range. Alternatively, it is possible to display the number of executions carried out by the total Top SQL statements displayed in the table above.

SQL Statement Details page

The SQL Statement Details page provides detailed graphic and textual data over the selected SQL Statement.

This page contains the panes described in the following sections:

•

SQL activity on page 36

•

SQL text on page 36

•

SQL metrics on page 36

•

Pie charts on page 37

SQL activity

The SQL Activity pane displays the CPU workload and executions of the selected SQL statement, as well as all SQL statements displayed on the Top SQL Statements table. This pane is identical to the SQL Activity section on the Top SQL Statements panel.

SQL text

The SQL Text pane displays the short text of the selected SQL handle, and allows viewing the wider context of this text, namely: the SQL handle’s full text, the entire batch and the SQL Statement’s execution plan.

This pane displays the short SQL statement, whose maximum size is by default 256 characters. In addition, the pane includes the following buttons:

•

View Full Text—displays a popup with the SQL handle’s full text

•

View Batch—displays a popup with the full text of the entire batch to which the SQL handle belongs

•

View Plan—displays a popup that shows the SQL statement’s execution plan and allows downloading the execution plan (.sqlplan) file.

SQL metrics

The SQL Metrics pane contains a table with the selected SQL statement’s metrics, as follows:

Table 7.
Column	Description
Object Name	The name of the object from which the SQL statement was executed.
Executions	The number of executions that took place on this object since it was brought into the library cache. NOTE: The Executions parameter does not provide any informational value unless the Total option is selected. When selecting the option Per Execution, the value of this parameter is always one (1).
Elapsed Time	The total time consumed for carrying out the SQL statement executions.
CPU Time	The total CPU time consumed for carrying out the SQL statement executions.
CLR Time	If the statement executed one or more CLR objects, the time consumed for these executions.
Total I/O Operations	The total number of reads, both physical and logical, carried out by the selected SQL statement.
Physical Reads	The total number of physical reads carried out by the selected SQL statement.
Logical Reads	The total number of logical reads carried out by the selected SQL statement.

Pie charts

The Pie Charts pane includes the pie charts listed below, which display the activity during the selected time range for the selected metrics.

•

Total CPU Time—the total CPU time consumed for executing the selected SQL statement, compared with the CPU time consumed for executing all of the SQL statements

•

Executions—the number of times the SQL script executed for a the selected SQL handle, compared with the total SQL statements

•

Logical Reads—the total number of logical reads for the selected SQL statement, compared with the total SQL statements

•

Physical Reads—the total number of physical reads for the selected SQL statement, compared with the total SQL statements

Monitoring Bandwidth Usage

The Bandwidth Usage panel allows tracking the bandwidth usage in the monitored database, compared with the currently used database edition and bandwidth cost model. This panel’s breakdown of the bandwidth usage to external and internal data transfer, with incoming and outgoing data flow in each section, provides a clear picture of how appropriate the current cost model is.

This panel allows carrying out the tasks detailed in the following sections:

•

Reviewing bandwidth usage and estimated costs on page 37

•

Reviewing external data transfer on page 39

•

Reviewing internal data transfer on page 39