Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server®

Expensive SQL tuning effort by the human expert
It may be up to days or weeks for a DBA or experienced SQL developer to tune a problematic SQL statement. SQL tuning is a very skillful job that not many developers can carry out in an enterprise. Should such expensive and valuable time be saved and used for other even more productive tasks inside a company?

What is Tosska SQL Tuning Expert Pro for SQL Server?
Tosska SQL Tuning Expert Pro is a complete SQL tuning solution that provides SQL syntax rewrite, Query Hints injection, and index recommendation to maximize the performance of a SQL without compromise in any specific feature’s limitation.

World’s Leading A.I. SQL Rewrite technology for SQL Server database
Manually rewriting SQL syntax to tune a SQL statement is commonly adopted by experienced developers and DBAs, but the effort and cost to rewrite a SQL statement are quite expensive. It requires an in-depth SQL tuning knowledge developer to spend hours or even days to rewrite and test a problematic SQL statement, and the tuning result might not be the best among most potential SQL rewrites due to the limitation of manual effort.  Tosska A.I. SQL Rewrite Engine is the world’s leading machine SQL Rewrite technology for SQL Server database. It not only saves the developer’s time to rewrite a problematic SQL statement to make it faster, but it also explores the potential best SQL syntax that even an experienced developer cannot discover. Moreover, Tosska A.I. rewritten SQL syntax can work with our Hints-injection algorithm to further explore more potential query plans that even most experienced developers cannot achieve.

 

Example: 10 times faster SQL Hints Injection is generated on the right-hand side

World’s Leading A.I. SQL Tuning Tool for SET ROWCOUNT N
Set Rowcount N causes SQL Server to stop processing the query after the specified N rows are returned. There are not many people who know that the SQL’s query plan may be affected by this setting, some SQLs’ performance may be degraded due to the SQL Server trying to optimize the SQL for the first N rows, but resulting in an even worse query plan. It is difficult for developers to tune this kind of problem without a good tool. Tosska SQL Tuning Expert for SQL Server is the first tool that can solve this problem automatically with our A.I. engine.

Powerful Cold Cache SQL Tuning for Infrequent Executed SQL Statements
For SQL statements that are not executed frequently, so that the relevant data is no longer exists in the buffer cache, a cold cache will significantly affect the performance of a SQL statement. A good performance SQL for hot cache may not be performing well in a cold cache environment. Experience developers will tune their SQL running well for both scenarios. Tosska SQL Tuning Expert for SQL Server provides a handy function for users to benchmark SQL alternatives in both environments without complicated manual operations.

Finding the best solution without trial and error
With Tosska SQL Tuning Expert for SQL Server, you no longer need to rewrite or try every possible Hints combination manually for a problematic SQL statement to explore potential better performance execution plans, since all those hard tasks are released by our embedded AI engine. Our intelligent engine will help you to find every possible rewrite and Hints combination to improve your SQL speed without the need for your intervention. You just sit back, relax, and wait for the best SQL alternative to come up on your screen.

Best alternative found after automatic SQL tuning

On-the-job SQL training for in-house SQL developers
A SQL query is used to retrieve data from your database. However, there may be multiple SQL queries that generate the same results but with different levels of efficiency. An inefficient query can drain the database resources, reduce the database speed or even result in a loss of service for other users. So it is very important to improve the in-house SQL developers with solid SQL writing skills. A short-term SQL training course may be helpful, but it is not sustainable to resolve all daily SQL writing challenges. Tosska SQL Tuning Expert inbuilt SQL Rewrite Engine can help developers to correct minor mistakes and generate many semantically-equivalent SQL rewrites for a user to compare with their original SQL syntax. Users can observe the SQL syntax, query plans, data distribution, and SQL performance of semantically-equivalent SQL to select the best SQL syntax to replace their original SQL statement. With the on-the-job SQL training process, it not only guarantees good SQL quality produced during the development cycle but also improves the in-house developers’ SQL writing skills through the process.

SQL index tuning that exceeds human capabilities
For mission-critical SQL statements, you may want to add indexes to the SQL to further optimize the statement to the ultimate performance without compromising the overhead of additional indexes. Tosska SQL Tuning Expert Pro provides an A.I. index tuning that tunes your SQL by exploring the most effective potential new indexes that even an expert cannot imagine.

Do not undermine your SQL Server’s potential ability
For some SQL statements that are failed to be tuned by syntax rewrite, hints injection, and all necessary indexes are built, people may think that hardware upgrade is the only way to resolve the performance problem. But, please don’t undermine your SQL Server’s SQL optimizer which can provide you with the ultimate performance solution that you may not have imagined before. What you need to do is to provide SQL Server with a set of proper new indexes. Tosska SQL Tuning Expert Pro is in-built with an A.I. engine to recommend indexes for multiple tables at the same time for a SQL statement. The new technology is so powerful to recommend multiple tables’ new indexes for a SQL at the same time, it means that how each new table’s indexes affect each other in the query plan will be considered by the engine. It is very helpful for SQL Server’s SQL optimizer to explore more potential query plans that could not be generated before. So, don’t undermine your SQL Server’s ability. Instead, use the right tool to tune your SQL statements before you are planning to upgrade your hardware.

Example: 80 times faster A.I. SQL index recommendation