Chat now with support
Chat with Support
Self Service Tools
Knowledge Base
My Account
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
My Account
My Groups
My License Assets
My Products
My Profile
My Service Request
My Warranty Assets
Contact Us
Customer Service
Licensing Assistance
Renewals Representative
View All

Download Quest SQL Optimizer for SQL Server 10.1.2 MSI Installer

Return


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.