サポートと今すぐチャット
サポートとのチャット

Foglight for SQL Azure 5.5.8.6 - User Guide

Introducing Foglight for SQL Azure Adding and Configuring Agents Reviewing SQL Azure Activity Reviewing Database Usage Reviewing the Database Properties Monitoring Estimated Costs Viewing User Metrics Using the Global Administration Options Reviewing Foglight for SQL Azure Alarms Glossary

Top SQL Statements table

The Top SQL Statements table displays the SQL statements that experienced the longest time of CPU consumption or total wait events during the selected time range.
Selecting the leftmost button of the row displays the workload and executions of the selected SQL statement on the SQL Activity section below. For details, see SQL Activity section on page 35.
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
関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択