SQL Optimizer for SQL Server® is the most comprehensive optimization solution available for SQL Server environments. SQL Optimizer helps you shorten tuning time and optimizes database performance. You can:
-Scan SQL statements embedded within database objects, SQL Server Profiler files, and application source code.
-Generate SQL statement alternatives for problematic SQL statements.
-Test SQL alternatives to find the best performing statement for your database environment.
-Generate index alternatives to improve database performance.
-Test index alternatives to find the alternative that provides the greatest performance gain.
-Optimize execution plans and deploy plan guides for SQL statements without changing original source code.
-Manage plan guides, including migrating plan guides from one database to another, importing plan guides from a file or exporting plan guides to a file as an archive, and enabling or disabling one plan guide from a batch of plan guides.
-Locate the most resource-intensive SQL in your server from the Plan Cache and from trace files and trace tables in SQL Profiler.