SQL Optimizer for SQL Server 10.1.2.1133

SQL Optimizer for SQL Server is the most comprehensive optimization solution available for SQL Server environments. This component offers complete SQL performance optimization with problematic SQL detection, automated SQL optimization and benchmarking capabilities. With it you can lower I/O and CPU costs with optimized SQL statements, reduce the learning curve by providing an intuitive SQL optimization environment, streamline the SQL optimization process by avoiding the trial and error method involved with manual SQL tuning.

Quest SQL Optimizer for SQL Server uses the following SQL optimization workflow to help you ensure that your SQL statements perform optimally in your database environment:

- Identify Problematic SQL Statements
The SQL Scanner locates and extracts problematic SQL statements directly from your source code without execution. SQL Scanner analyzes the operations of the execution plan and identifies potential performance bottlenecks. Note: You need to use Microsoft SQL Server Profiler to capture dynamic SQL statements. Save the captured dynamic SQL statements into a trace file or trace table and use SQL Scanner to extract the statements.

- Optimize SQL Statements
The SQL Optimizer uses artificial intelligence to generate alternatives with unique execution plans for problematic SQL statements. SQL Optimizer generates the alternatives by analyzing SQL statement syntax and database structure. You can also use hints during the optimization process. See "Optimize SQL Statements" in the online help for more information.

- Test Run SQL Alternatives
The Test Run function tests the performance of each alternative SQL Optimizer generates. This provides execution times for each alternative to determine the best statement for your database environment. See "Execute SQL Alternatives" in the online help for more information.

- Compare SQL Alternatives
The Compare feature displays details for two SQL statements side-by-side. You can compare an alternative to the original SQL statement or compare two alternatives. See "Compare SQL Statements" in the online help for more information.

- Generate Reports
The Report feature creates a SQL resolution report after you complete the optimization process.

SQL Scanner
SQL Scanner extracts SQL statements embedded in database objects, captured from SQL Profiler, or stored in application source code and binary files. SQL Scanner retrieves and analyzes execution plans for extracted SQL statements from SQL Server to identify statements with performance bottlenecks. You can copy statements classified as problematic (first priority) or complex (second priority) into SQL Optimizer for analysis.

View SQL Classification
SQL Scanner extracts syntactically correct SQL statements and retrieves their execution plans. SQL Scanner then classifies the extracted statements as Simple, Complex, Problematic, or Invalid. You can view the classification of extracted statements by scan jobs or individually.

Send to Optimize SQL
You can optimize SQL statements extracted by SQL Scanner using SQL Optimizer. SQL Optimizer supports single INSERT, UPDATE, SELECT, DELETE, or MERGE SQL statements.

Find SQL from Plan Cache
Find SQL helps you locate the most resource-intensive SQL in your server. It evaluates existing SQL performance by different statistics (such as CPU time and elapsed time) from different areas (such as batches and database objects).

Find SQL from SQL Trace
Find SQL from SQL Trace allows you to extract SQL statements and their performance statistics from trace files or trace tables collected by SQL Profiler. You can identify the most resource-intensive SQL statements in your traces. Additionally, you can:

• Extract SQL executed in your server through SQL Trace
• Review execution statistics and query plans of the SQL
• Check resource consumption in SQL, Batch and Database Object levels
• Optimize the performance of your SQL by sending them to Optimize SQL or Optimize Indexes
• Save a SQL and its XML plan for others to review

SQL Trace Templates
Find SQL requires certain event columns in your trace in order to analyze it. For your convenience, SQL Optimizer provides trace template files (.tdf) for you to use. The template files are located in the Find SQL - Trace Templates folder in the SQL Optimizer installation directory.