サポートと今すぐチャット
サポートとのチャット

SQL Optimizer for SQL Server 10.1.2 - User Guide

Welcome to SQL Optimizer Optimize SQL
Create Optimize SQL Sessions Open Optimize SQL Sessions Rewrite SQL Plan Control Use Temporary Tables
Optimize Indexes Find SQL Scan SQL Manage Plan Guides Configure Options Tutorials About Us

Tutorial: Optimize Indexes

To optimize indexes

  1. Select the Optimize Indexes tab.
  2. Click Define New SQL Workload.

  3. Select the type of SQL workload source from which you want to collect SQL.

    SQL Workload Source Description
    Scan Code Scan SQL statements from file, database object source, or clipboard.
    Plan Cache Collect SQL from the Plan Cache.
    SQL Profiler

    Collect SQL with built-in SQL Profiler or load SQL from a trace file or a trace table.

    Spotlight Statistics Repository Collect SQL from Spotlight Statistics Repository.

    Note: Depending on the workload source you select, you may need to select a database connection from which to collect SQL.

  4. Specify the SQL filter criteria. For specific instructions on specifying criteria for collecting SQL and for optimizing indexes for the type of SQL source you selected, see one of the following:

  5. To begin collecting SQL, click .
  6. Optimize Indexes immediately asks you to choose a second database connection. Select a database connection to use to retrieve execution plans and evaluate index alternatives.

    Note: This step allows you to select an alternate database (other than the one used to collect SQL) to run the index optimization process. In other words, you can collect your SQL from one database, but run the optimize indexes process on a second database. The second database must have the same application environment and data volume statistics as the first.

    The Search Process page opens during the collection process. Before specifying search process criteria, you can review and modify your SQL workload.

    Notes:

    • To restart the SQL collection process, click Collected from <source> to return to the SQL Criteria page. Then click restarted.
    • Click Advanced options to modify your SQL workload before starting the index evaluation process.
  7. Click to begin the index evaluation process.

    Note: You can schedule the index evaluation process on a specific date and time.

  8. Select the Search Process tab to review details related to the search process. Each line on the graph indicates a new indexing recommendation.
  9. Select the Results tab to view the final recommendation (or the last recommendation if the search process is ongoing).

  

Tutorial: 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 don 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.
This topic may not include a description for every field in the screen or dialog.

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

Export, Import, and Migrate Plan Guides

Send to SQL Optimizer

About Us

Quest creates software solutions that make the benefits of new technology real in an increasingly complex IT landscape. From database and systems management, to Active Directory and Office 365 management, and cyber security resilience, Quest helps customers solve their next IT challenge now.

Around the globe, more than 130,000 companies and 95% of the Fortune 500 count on Quest to deliver proactive management and monitoring for the next enterprise initiative, find the next solution for complex Microsoft challenges and stay ahead of the next threat.

Quest Software. Where next meets now. For more information, visit www.quest.com.

Contact Quest

For sales or other inquiries, visit www.quest.com/contact.

Technical Support Resources

Technical support is available to Quest customers with a valid maintenance contract and customers who have trial versions. You can access the Quest Support Portal at https://support.quest.com.

The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. The Support Portal enables you to:

  • Submit and manage a Service Request
  • View Knowledge Base articles
  • Sign up for product notifications
  • Download software and technical documentation
  • View how-to-videos
  • Engage in community discussions
  • Chat with support engineers online
  • View services to assist you with your product

SQL Optimizer Community

You can also find help and additional information at the SQL Optimizer community at: https://blog.toadworld.com/tag/sql-optimizer-for-sql-server

  

Related Topics

About Us

Quest creates software solutions that make the benefits of new technology real in an increasingly complex IT landscape. From database and systems management, to Active Directory and Office 365 management, and cyber security resilience, Quest helps customers solve their next IT challenge now.

Around the globe, more than 130,000 companies and 95% of the Fortune 500 count on Quest to deliver proactive management and monitoring for the next enterprise initiative, find the next solution for complex Microsoft challenges and stay ahead of the next threat.

Quest Software. Where next meets now. For more information, visit www.quest.com.

Contact Quest

For sales or other inquiries, visit www.quest.com/contact.

Technical Support Resources

Technical support is available to Quest customers with a valid maintenance contract and customers who have trial versions. You can access the Quest Support Portal at https://support.quest.com.

The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. The Support Portal enables you to:

  • Submit and manage a Service Request
  • View Knowledge Base articles
  • Sign up for product notifications
  • Download software and technical documentation
  • View how-to-videos
  • Engage in community discussions
  • Chat with support engineers online
  • View services to assist you with your product

SQL Optimizer Community

You can also find help and additional information at the SQL Optimizer community at: https://blog.toadworld.com/tag/sql-optimizer-for-sql-server

  

Related Topics

関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択