Seamless integration to Microsoft Visual Studio
The SQL Optimizer is an extension or plug-in to Visual Studio. As such, the user experience is within the Visual Studio environment. Because the experience is the same, it won’t take the developer long to learn how to use SQL Optimizer. This provides a fast return on investment.
Identifies problematic and poor performing SQL code
By using a static code check, SQL Optimizer can quickly scan SQL statements embedded in code, projects and schema objects. It will classify the code as simple, complex or problematic SQL code from the Visual Studio editor, the Solution Explorer or Projects. This removes the complexity of identifying poor performing code.
Automates process of optimizing multiple statements
Identified SQL statements will be placed in a queue for automatic or scheduled optimization. This allows the developer to continue to work inside of Visual Studio while SQL Optimizer optimizes code.
Rewrites SQL to find the absolute fastest SQL statement
SQL Optimizer uses proprietary technology that automatically rewrites SQL statements by applying code transformations. Code transformations generate all possible ways SQL can be written to extract the data from the database. It will then locate the SQL statement that provides the fastest execution time. This exploits the power and performance of applications and SQL-Server.
Validates SQL for correct data returned and improved SQL performance
As part of the rewrite process, SQL Optimizer automatically validates the result set between the new SQL statements and the original SQL statement. This guarantees the proper data is the data returned for the new SQL statement. For more hand on users, detail graphs and screens are provided to compare the statements, explain plans, I/O and runtime metrics.
Deploys optimized SQL in Visual Studio files and projects
Once SQL Optimizer has located the fastest SQL, the original source code will be updated with optimized SQL. With just one click you can deploy the optimized SQL in the source code and position where the original SQL is located. There is no need to copy and paste or otherwise move the SQL.
Easy to use
The SQL Optimizer is a client based only tool. There is nothing to install on a server or database. A download and install and the developer is up and running. In a matter of minutes any developer can make SQL run faster.
Configurations
SQL Optimizer for Visual Studio will be sold by individual seats.