SQL Optimizer for SQL Server 10.1.2 - User Guide

Create Manage Plan Guides Session

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To create a new session

1. Select the Manage Plan Guides tab in the main window.

2. Click . The Create Manage Plan Session Guide window displays.

   Note: You can also click to create a new session.

3. Review the following for additional information:

   Select Connection	Description
   Connection	Click to select a previously created connection. Tip: Click to open the Connection Manager to create a new connection. See Connect to SQL Server for more information.
   Select Database	Description
   Database	Click to select the database to match your SQL statement.

Note: You cannot change the database connection for a Manage Plans session. You must create a new session to use a different connection.

Related Topics

About Managing Plan Guides

Manage Plan Guides

Plan Guides Management displays SQL Server plan guides deployed from Plan Control mode in Optimize SQL.

To manage a plan guide

1. Select the Manage Plan Guides tab in the main window.

   Note: You need to create a new Manage Plans session before managing your stored plan guides. See Create Manage Plan Guides Session for more information.

2. Select a plan guide deployed from the Optimize SQL module in the Plan Guides pane.

   Tip: Click or if you do not see a plan guide that you deployed from Optimize SQL.

3. Select the checkbox in the Enabled column to enable the plan guide.

Toolbar Functions

Button/Function	Description
	Enable plan guides.
	Disable plan guides.
	Validate the plan guide.
	Drop the plan guide.
	Refresh the plan guide.
	Display the filter panel.
	Migrate a plan guide.
	Import a plan guide.
	Export a plan guide.

To export a plan guide

1. Select the Manage Plan Guides from the main window.

2. Select a plan guide in the Plan Guides pane.

   Tip: Press CTRL to select multiple plan guides when clicking a plan guide.

3. Select .

4. Select a file name and location for your export file.

To import a plan guide

1. Select .

2. Select a file to import.

3. Review the following for additional information:

   Existing Plan Guides	Select on of the following when there is a plan guide with identical SQL script found: Skip the new plan guide. Replace the existing plan guide.
   Backup for Target Database	Backup the existing plan guides before importing and specify the backup file name and folder path.

To migrate a plan guide

1. Select .

2. Click in the Target Connection field and select a connection.

   Tip: Click to create a new connection.

3. Click in the Target Database field and select a database for your plan guides.

4. Review the following for additional information:

   Existing Plan Guides	Select on of the following when there is a plan guide with identical SQL script found: Skip the new plan guide. Replace the existing plan guide.
   Backup for Target Database	Backup the existing plan guides before importing and specify the backup file name and folder path.

Tip: To specify a default name for the output or backup file when exporting or migrating plan guides, go to Options | Manage Plan Guides.

Related Topics  

About Managing Plan Guides

Export, Import, and Migrate Plan Guides

Send to SQL Optimizer

Filter Columns

To filter a column

»

Click to the right of the column header and select a filtering option.

Note: When filtering is applied to columns, displays to the right of the column header. A Filter panel also displays at the bottom of the grid that describes applied filters as illustrated in the following:

Tips:

• Click in the Filter panel to clear a filter or right-click a filtered column and select Clear Filter.

• Click in the Filter panel to enable or disable a filter.

• Click in the Filter panel to select a previously defined filter.

Export, Import, and Migrate Plan Guides

To export a plan guide

1. Select the Manage Plan Guides from the main window.

2. Select a plan guide in the Plan Guides pane.

   Tip: Press CTRL to select multiple plan guides when clicking a plan guide.

3. Select .

4. Select a file name and location for your export file.

To import a plan guide

1. Select .

2. Select a file to import.

3. Review the following for additional information:

   Existing Plan Guides	Select on of the following when there is a plan guide with identical SQL script found: Skip the new plan guide. Replace the existing plan guide.
   Backup for Target Database	Backup the existing plan guides before importing and specify the backup file name and folder path.

To migrate a plan guide

1. Select .

2. Click in the Target Connection field and select a connection.

   Tip: Click to create a new connection.

3. Click in the Target Database field and select a database for your plan guides.

4. Review the following for additional information:

   Existing Plan Guides	Select on of the following when there is a plan guide with identical SQL script found: Skip the new plan guide. Replace the existing plan guide.
   Backup for Target Database	Backup the existing plan guides before importing and specify the backup file name and folder path.

Related Topics  

Manage Plan Guides