Page History
...
Table 10-10 Sort order icons
Sort order icon Description
...
Sort Order Icon | Description |
---|---|
Indicates whether the data in the column will be stored in the index in ascending order. | |
...
Indicates whether the data in the column will be stored in the index in descending order. |
...
Indicates that column is part of the INCLUDE statement. |
About the DDL tab
Displays the DDL text of the recommended index or statistic or the SQL Server 2005 recommendation.
About the Table's Indexes/Statistics tab
Displays a list of the existing indexes or statistics for the table selected in the recommendation area. The following information is displayed:
Indicates that the item is an index. Indicates
Indicates that the item is a statistic.
Name Displays Name Displays the name of the index or statistic.
Clustered Indicates Clustered Indicates whether the index is clustered. (This parameter is not relevant for a statistic.) Unique Indicates
Unique Indicates whether the index is unique. (This parameter is not relevant for a statistic.)
Columns A Columns A list of the columns of the index or statistic columns separated by a comma. If the recommended item is an index, the sort order (ascending/descending) is also displayed.
Info |
---|
...
This tab is not available for create partition function or create partition schema recommendations. |
About the Text tab
Displays the selected statement's text or batch's text.
Evaluating a set of recommendations using the What-if tab
The What-If tab shows the number of statements whose cost would increase and the number of statements whose cost would decrease if the recommendation was implemented. It also shows the cost of implementing the recommendation so that you can weigh the pros and cons of implementing the change.
...
- In the Recommendations table in the left pane, select the check boxes of the recommendations you want to test. Clear the check boxes of the recommendations you do not want to test.
- On the What-If tab, click the What-If link.
Info |
---|
...
If you change the time frame, the information displayed in the What-If tab is automatically calculated and the display is refreshed. |
About observing the history of resource consumption
The History view displays resource consumption over time vs. changes in various parameters to determine which changes led to performance problems.
...
- Main area
- Change history area
About the Main area
The Main area (upper area) displays resource consumption over time vs. cost and changes over time.
About viewing a history of resource consumption over time
The Main area displays resource consumption over time in the following views:
- History Displays History. Displays resource consumption over time in the following graphs:
- In MS-SQL. Displays the resource consumption of the selected statement over a specified time period.
- Cost. Displays the estimated cost of the selected statement over a specified time period. Displays the actual and estimated costs for SQL Server 2005 statements.
- Changes vs. Duration (avg). Displays change indications for the statement and its related objects vs. average duration over a specified time period.
- Executions. Displays the number of executions of the selected statement over a specified time period.
- Text Displays Text. Displays the statement's text.
About the Change History area
The Change History area (lower area) displays all the changes made to various parameters over a specified time period.
...
- All changes
- Schema changes
- Estimated access plan changes
- Actual access plan changes
- Instance parameters changes
- Database options changes
- Volume changes
About viewing all changes
The All Changes view displays a list of all changes made to various parameters over a specified time period. The changes can be schema changes, access plan changes, instance parameters changes, database changes and volume changes.
...
Table 10-11 All Changes table
Column |
---|
...
Description |
---|
...
...
If the object that was changed is one of the entities in the Objects tab (Instance, Database, Table and Index), the Launch icon opens the Objects tab with the selected object, in-context. Also, if the change type is "Access Plan Changed" the icon will launch the Compare View with the specified access plan compared to the last access path, as detected by the "Explain Statements" process. |
...
Date | Indicates the date the change was detected. Click on the link to switch to Plan view and display the first access plan that was created by the Explain Statements process after the specified change was detected. |
Change |
...
Type | Displays the type of change detected. Can be one of the following values: |
...
|
...
|
...
|
...
|
...
|
...
|
...
Object | Indicates the object that was changed, for example, database, table, and index. |
...
Details | Displays information about the change that was made. For example if the "Auto Shrink File" option was changed in the specified database the Details column will contain: "Auto Shrink File (From NO to YES). |
About viewing schema changes
The Schema Changes view displays a list of all schema type changes made to various parameters over a specified time period.
...
Table 10-12 Schema Changes table
Column |
---|
...
Description |
---|
...
...
If the object that was changed is one of the entities in the Objects tab (Instance, Database, Table and Index), the Launch icon opens the Objects tab with the selected object, in-context. Also, if the change type is "Access Plan Changed" the icon will launch the Compare View with the specified access plan compared to the last access path, as detected by the "Explain Statements" process. |
...
Date | Indicates the date the change was detected. Click on the link to switch to Plan view and display the first access plan that was created by the Explain Statements process after the specified change was detected. |
Change |
...
Type | Displays the type of schema change detected. Can be one of the following values: |
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
Object |
...
Indicates the object that was changed, for example, database, table, and index. |
...
Details | Displays information about the change that was made. For example if the "Auto Shrink File" option was changed in the specified database the Details column will contain: "Auto Shrink File (From NO to YES). |
About viewing estimated access plan changes
...
Indicates that column is part of the INCLUDE statement.