Chatee ahora con Soporte
Chat con el soporte

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

Animate Execution Plans

You can animate each step in the execution plan in the order SQL Optimizer executes them.

To animate the execution plan or cancel the animation

» Right-click the execution plan and select Animate Plan Steps.

 

Related Topics

Copy Execution Plans

Fill Missing Execution Plans

 

Copy Execution Plans

To copy an execution plan

» Right-click the execution plan and select Copy.

Note: You can paste execution plans displayed as a Tree Plan or Plain Language Plan in text or bitmap format. Applications such as Microsoft Word allow you to choose the format using the Paste Special option. You can use text applications such as Notepad to paste execution plans in text format or graphic applications such as MS Paint to paste execution plans in bitmap format.

 

Related Topics

Fill Missing Execution Plans

 

Find SQL

Find SQL helps you locate the most resource-intensive SQL in your server. You can use Find SQL to inspect SQL captured by Plan Cache and SQL Profiler.

Find SQL from Plan Cache evaluates existing SQL performance to find the most resource-intensive SQL statements. Resource usage such as CPU Time and Elapsed Time are evaluated. You can view the top consuming SQL statements from different areas, such as batches or database objects.

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:

  • Review execution statistics and query plans of the SQL
  • Check resource consumption at the 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

 

Related Topics

About Finding SQL

Find SQL helps you locate the most resource-intensive SQL in your server. You can use Find SQL to inspect SQL captured by Plan Cache and SQL Profiler.

Find SQL from Plan Cache evaluates existing SQL performance to find the most resource-intensive SQL statements. Resource usage such as CPU Time and Elapsed Time are evaluated. You can view the top consuming SQL statements from different areas, such as batches or database objects.

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:

  • Review execution statistics and query plans of the SQL
  • Check resource consumption at the 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

 

Related Topics

Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación