New Analysis Wizard: Analyzer Page
View New Analysis Wizard--Analyzer Page
In the New Analysis wizard, the Analyzer page is used to name the analysis and to select the folder where the Analyzer information will be stored.
Creating a new Analyzer and select SQL to be analyzed
Select this option to create a new analysis using a different set of SQL statements.
Continuing an existing Analyzer using the Analyzer's selected SQL
Select this option to use the same set of SQL statements that is stored in an existing Analyzer. This option adds another Scenario under an existing Analyzer and does not retrieve a new set of query plans for the SQL statements. It uses the query plans that were originally saved with the SQL statements.
Do not drop the indexes after the analysis is finished
Specific to leaves the new indexes that you create under the Index tab after the analysis is finished. Otherwise, these changes are dropped at the end of the analysis processing. After the analysis is complete, the Create/Drop Indexes button displays at the top of the Index Impact Analyzer window which displays the Create Indexes, Drop Indexes, and the Drop All Indexes panes. These panes contain the scripts to create or drop the indexes.
| Item | Description |
|
Name |
Enter the name for the analysis. |
|
Description |
Enter the description for the analysis. |
|
Last modified |
Displays the last modified date and time. |
|
Save location |
Displays the folder in the tree where the Analyzer is saved. |
|
Folder Tree |
In the bottom pane, select the folder where you want to save the Analyzer. |
|
|
To create a new folder, click Add Folder. |
