In Find SQL, the Search Results page is a dashboard-style summary of search results from either Plan Cache or SQL Trace.
This page allows you to see at-a-glance the top-consuming SQL for each cost (resource) type. The top row shows the total top-consuming SQL for each cost type. The next two rows show top-consuming SQL batches and database objects for each cost type.
Click a pie chart to go directly to the list of top-consuming SQL for that cost type (for either total SQL, most-expensive batches, or most-expensive database objects).
The dashboard-style Search Results page allows you to:
Use the Resources Consumed pane to find which SQL statements consume the most resources according to different cost types.
The dashboard displays a summary of results based on statistic totals (not averages).
The number of SQL used in each graph is the Top n SQL suggested by SQL Optimizer.
To use the Resources Consumed dashboard
The Search Results page remembers your last view and provides a link for easy return. One custom view link is provided for each row (statements, batches, or database objects).
Note: Each new view you select overwrites the last view link.
Use the SQL Classification panel to view the collected SQL statements grouped by SQL classification (problematic, complex, simple, or invalid). Click a section of the pie chart to view the list of SQL in that classification category.
To use the SQL Classification panel
Click a color-coded category in the SQL classification pie chart or the legend to view the list of SQL in that category. The SQL by Classification page opens. See SQL by Classification Page for more information.
Tip: For descriptions of the SQL classification categories, see SQL Classification Categories.
The Search Results page remembers your last view and provides a link for easy return.
Note: Each new view you select overwrites the last view link.
The upper grid of the Top SQL Statements page displays the resource consumption of SQL according to criteria you select. The lower grid displays statistics according to criteria you select.
Select criteria from across the top of the upper grid to display the resource consumption of SQL. Review the following for additional information:
Resource Consumption of SQL | Description |
Top n SQL |
Click and select from the following criteria to specify the number of SQL:
|
Performance method |
Click and select to specify performance method. |
Compare Statistics |
Click to display comparison of selected statistics. |
Selected Statistics |
Click and select statistics to which you want to compare with criteria previously selected. |
The chart in the middle of the upper grid displays information based on all the criteria you selected.
The lower part of the upper grid displays a complete summary of the consumption of SQL. based on the criteria you selected in Top n SQL and the performance method.The information includes the total number of SQL collected out of the number of SQL in the server. A graphic on the right side displays a visual representation of the total resource consumption.
Statistics for your top SQL display in the lower grid. Review the following for additional information:
Top SQL | Description |
View Statistics |
Select one of the following:
|
Columns | Description |
SQL |
Right click a SQL to:
Select a SQL and click View Details in the upper-right of window to review SQL details. See Top SQL - Details View (SQL Trace). |
Note: Click the drop-down arrow beside the search name in the breadcrumb navigation to select another view.
The Summary Chart view displays a summary of resources consumed by the Top Batches. This page also includes statistics for each batch in the group.
To view SQL statement details, click View Details. See Top Batches - Details View (SQL Trace) for more information.
Select criteria from across the top of the upper grid to display the resource consumption of batches. Review the following for additional information:
Resource Consumption of Batches | Description |
Top n batches |
Click and select from the following criteria to specify the number of batches:
|
Resource |
Click and select to specify resource. |
Compare Statistics |
Click to display a comparison of selected statistics.
|
The chart in the middle of the upper grid displays information based on the criteria you selected above.
The lower part of the upper grid displays a complete summary of the consumption of batches based on the criteria you selected in Top n batches. The information includes the total number of batches collected out of the number of batches in the whole trace.
A graphic on the right side displays a visual representation of the total resource consumption.
Statistics for your Top Batches display in the lower grid. Review the following for additional information:
Top Batches | Description |
View Statistics |
Select one of the following:
|
Columns | Description |
Batch |
Right click a batch to:
|
The Summary Chart view displays a summary of resources consumed by the Top Database Objects. This page also includes statistics for each SQL statement in the database object.
To view SQL statement details, click View Details. See Top Database Objects - Details View (SQL Trace) for more information.
Select criteria from across the top of the upper grid to display the resource consumption of database objects. Review the following for additional information:
Resource Consumption of Database Objects | Description |
Top n objects |
Click and select criterion to specify the number of objects.
|
Resource |
Click and to specify resource. |
Compare Statistics |
Click to display a comparison of selected statistics.
|
The chart in the middle of the upper grid displays information based on all the criteria you selected.
The lower part of the upper grid displays a complete summary of the consumption of SQL based on the criteria you selected in Top n objects and the resource selected. The information includes the total number of objects collected out of the number of objects in the whole trace.
Statistics for your Top Database Objects display in the lower grid. Review the following for additional information:
Top Database Objects | Description |
View Statistics |
Select one of the following:
|
Columns | Description |
Object |
Right click an object to:
|
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center