Query Statistics Screen

Query Statistics

The color-coded stacked lines of the SQL Statistics histogram display the top three (3) SQL Re-Compilations/sec. by Instance that fall within the specified range of time. The selected date range is displayed in the header of the SQL Statistics card.
To examine individual SQL Re-Compilations, the visual display can be changed to further identify which are occurring the most, as follows:

• Use the calendar widget to change the date range (default is last seven (7) days). The selected range is displayed on the card tool bar.
• Use the time widget to change the time interval displayed (Auto is one (1) hour).
• Use the slide toggles to filter the display by hiding or showing top Instance(s).
• Use the Environment, Instance, Database, Weekday, and Time of Day drop-down Filters to change the visualization. Depending on the filter(s) selected, the histogram will display the top three instances for that criteria.

Slicers

To filter the data in the dashboard displays, click the Slicer icon [ ///] to the right of the SQL Statistics card. Selections made in the Slicer is reflected in the Filters drop-downs at the top of the screen. The Slicer panel includes filters for:
Top Instances
Where the overview displays only the top three (3) instances, this slicer displays a sortable list of all Instances by CPU and I/O counts.
Top Databases
Displays a list of Databases by CPU and I/O counts.

SQL Statistics

The histogram in this card displays the top three (3) SQL Re-Compilations by Instance that fall within the specified range of time. To highlight data points, hover the cursor over the stacked, color-coded lines:

• Displays the average number of re-compilations over the time range below the slide toggles for each top Instance.
• The marker pop-up will display the number of re-compilations by date for the selected Instance(s). These values are also displayed below the slide toggles along with totals and averages based on percentage contribution.
• To concentrate the display on a specific time range, using the left button, select the block of time by dragging the cursor over the section of the display. The histogram will display only that time range refinement.

Top Events

This card groups result-sets in a searchable table format with sortable columns, as follows.

• The Instance column displays
• The Database column displays
• The Object column displays
• The SQL Statement column displays
• The Executions column displays
• The CPU column displays
• The Reads column displays
• The Duration column displays
• Hover the cursor over the column headings to sort the list in ascending or descending order.
  Query Statistics data can be further focused by using the Group By drop-down menu, as follows.
  Within each grouping:
• To display a pop-up of an entire SQL Statement that can be copied, click on the SQL Statement field.
• Click the row to view additional details on Query Statistics. See the Query Information section for more information.

Instance:

Displays a sortable list by Instance, Executions, CPU, Reads, and Duration.

• Click the arrow [>] to the left of the row to display more detailed information by Database, Object, SQL Statement, Executions, CPU, Reads, and Duration.
  By Database:
  Displays a sortable list by Database, Executions, CPU, Reads, and Duration .
• Click the arrow [>] to the left of the row to display more detailed information further by Instance, Object, SQL Statement, Executions, CPU, Reads, and Duration.
  By Object:
  Displays a sortable list by Object, Executions, CPU, Reads, and Duration.
• Click the arrow [>] to the left of the row to display Deadlock information further by Instance, Object, SQL Statement, Executions, CPU, Reads, and Duration.

SQL Statement:

Displays a sortable list by SQL Statements, Executions, CPU, Reads, and Duration.

• Click the arrow [>] to the left of the row to display Deadlock information further by Instance, Database, Object, Executions, CPU, Reads, and Duration.

Query Information

This flyout displays Query Details, Query History, and the SQL Statement for the selected Instance. and the corresponding Resource Details, as follows:

Details:

Query Details include the Properties and the corresponding Resource Details, Snippet Details and information on Executions, CPU, and Reads, as follows:

• Properties - This card displays the seven (7) day date range being examined and lists the Instance, Database, and Object.
• Resource Details - This card displays the Executions, CPU, Reads, and Duration.
• Snippet Details - This card displays the first six (6) lines of the SQL Statement. Click the View Statement button to display a flyout with the complete SQL Statement that can be copied or click the Copy Statement button to copy the statement for export and further analysis.

CPU & Reads

This histogram displays the number of executions over the specified time range for the selected Instance. The date range is displayed in the card header. Use the slide toggles to change the display to CPU or Reads.

• By default, this histogram displays the average number of executions over the time range below the slide toggle.
• The marker pop-up will display the number of executions by date for the selected Instance. Click the slide toggles for CPU and Reads to display totals and averages based on percentage contribution.
• To concentrate the display on a specific time range, using the left button, select the block of time by dragging the cursor over the section of the display. The histogram will display only that time range refinement.

Query History:

This card displays a sampling by the hour of the Total number and average Duration of Executions, the Average and Maximum for CPU duration, and the Average and Maximum for Reads.

• Hover the cursor over the column headings to sort the list in ascending or descending order.
  By SQL Statement:
  To display a flyout with the complete SQL Statement that can be copied, click the SQL Statement link in the Query Information header.