SQL details

Note

This section will not be displayed if there is no SQL diagnostics details.

Note

Only the Slow SQL details page displays the SQL Sampling Details section, and other SQL details pages do not display it.

Physical execution plan

On the Physical Execution Plan tab, view the execution plan details and bind the execution plan.

• By clicking the Plan Hash text, you can view the details of the corresponding physical execution plan.

  • View the specific application process of operators in the execution steps and the server execution plan.

  • Hovering over the object name in the execution plan allows you to view the table structure or DDL index information, etc. If the object is a table, you can view the table structure. If the object is an index, you can view DDL index information, etc.

• Click Custom and select Past 1 Hour, Past 12 Hours, or Past 1 Day from the drop-down list to quickly filter the query time period. You can also customize the query time period, but note the following limitations:

• Click Binding History in Last 30 Days to view the binding records of the physical execution plan for the last 30 days.

• Click Binding History in Last 30 Days to view the binding records of the physical execution plan for the last 30 days.

• Click Refresh Plan to clear the execution plan cache for this SQL statement. The next time this SQL statement is executed, a new execution plan will be generated.

SQL execution history

On the SQL Execution History tab, view the historical execution information of the current SQL statement, including Execution Time, Total Executions, and Total Database Time Consumption (ms).

* Only supports viewing SQL execution history for the last 15 days.

* Minimum Range Limit:

  * For data within 3 days: The selected time range must be at least 1 minute.

  * For data from 3 to 7 days: The selected time range must be at least 5 minutes.

  * For data beyond 7 days: The selected time range must be at least 20 minutes.

• Click the icon to download the SQL execution history list.

• Click icon to query more metrics in the popped-up window Manage Columns.

Table information

On the Table Information tab, you can view and bind indexes. If an index is bound to an SQL statement, the label Bound is displayed in the Actions column. You can also view table statistics on this tab.

Advanced settings

On the Advanced Settings tab, you can perform the following operations:

Throttling setting

1. In the Throttling Setting section, click Set Throttling.

2. Enter the Maximum Concurrent Requests and click OK.

3. In the dialog box that pops up, click OK.

Keyword throttling setting

1. In the Keyword Throttling Setting section, click Set Keyword Throttling.

2. In the refreshed page, click Settings below Throttling Keyword.

3. In the Set Throttling Keyword dialog box, enter a throttling keyword in the corresponding field, and click OK.

   Note

   You do not need to set all keywords. If you enter a string with spaces, enclose the string in full-width quotation marks or single quotation marks.

4. Set the Maximum Concurrent Requests for Keyword and click OK.

   Note

   The maximum concurrent requests for a keyword take effect independently.

5. In the dialog box that pops up, click OK.

Outline setting

1. In the Outline Setting section, click Set Outline.

2. Enter the outline and click OK.

3. In the dialog box that pops up, click OK.