Tosska DB Ace Enterprise for SQL Server



ALTERNATIVE WISDOM –

Intelligent SQL Tuning Beyond Human Wisdom



What is Tosska DB Ace for SQL Server?
Tosska DB Ace is a complete SQL tuning solution that provides the world’s leading automatic SQL syntax rewrite, Query Hints injection, Plan Guide SQL tuning, Query Store SQL tuning, and index recommendation to maximize the performance of a SQL statement for MS SQL Server.

Module Name Description
Tune SQL – Rewrite & Hints Injection Use AI SQL Rewrite and Hints Injection technology to tune a SQL statement.
Demo videos: Tune SQLTune SQL 1stTune SQL Setrowcount
Tune SQL – Index Advise Use an AI algorithm to recommend indexes to improve a SQL statement.
Demo video: Tune SQL Index
Tune SQL with Plan Guide Tune SQL with the Plan Guide without the need to change the program source code.
Demo videos: Tune PG standaloneTune PG BatchTune PG Object
Tune SQL with Query Store Extract SQL from Query Store and tune it without the need to change the program source code.
Demo video: Tune SQL QS
Manage Plan Guide Enable/disable and manage deployed Plan Guide.
Manage Query Store Enable/disable and manage forced queries in Query Store

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 rewriting and testing 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 the most experienced developers cannot achieve.

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

How to tune SQL when you can’t edit your source code ?
What would you do with the following scenarios? If you are a package application user, how you can tune your SQL if you can’t edit a SQL directly? Or, if you are an application developer, what would you do if you want a quick fix on SQL performance without the time to go through source code change and unit tests? There are two features provided by SQL Server: Plan Guide and Query Store. But the use of these features is limited by hints injection only, you cannot rewrite a SQL with a different syntax and force the original SQL to accept a rewritten SQL’s query plan. So, hints-based SQL tuning is becoming more important than ever before. Tosska DB Ace is the only tool that can provide the most advanced Auto-Hints-Injection solution in the market to fully automate the process from SQL tuning to better query plan deployment.

Ad-hoc SQL tuning becomes easier
Some SQL statements may be executed with a sudden high volume of data such as month-end or year-end processes. If the SQL Server’s optimizer cannot generate a good plan immediately, the process may be prolonged and the business is affected. So, preventative measures should be carried out before the SQL statements are executed, and better query plans controlled by the Plan Guide or forced plan in Query Store before starting the processes. Users can disable the plan control after the processes are finished and resume those query plans back to normal status for better daily operations.

SQL tuning with Plan Guide without the need to change source code
Plan guides let you optimize the performance of queries when you cannot or do not want to directly change the text of the actual SQL in SQL Server. But there is a lack of this kind of product in the market that can automatically generate a better Plan Guide for users’ SQL. Tosska DB Ace for SQL Server is an innovative product that can tune a SQL statement by automatically generating a better Plan Guide for your SQL statements without the need to change your source code.

The best Plan Guide found for the SQL statement

Tune SQL with the Plan Guide module comes with an easy SQL extraction feature that can help users to extract SQL from SQL batch text and database objects. The feature also helps users to identify the right source of the SQL before the deployment of the Plan Guide.

Automatic SQL extraction from a SQL batch text
Automatic SQL extraction from a database object

DB Ace brings Query Store to the new horizon of proactive SQL tuning
The Query Store is used for performance troubleshooting by helping users quickly find performance degradation caused by query plan changes. Although it is a good feature to regulate a performance-degraded SQL statement due to the query plan changes, it is difficult for users to improve a SQL statement if a better query plan was not generated before, which means SQL Server’s Query Store is designed to recover a degraded SQL’s performance reactively.
Tosska DB Ace for SQL Server brings the SQL Server’s Query Store from the reactive SQL performance recovery mechanism to the new horizon of proactive SQL performance improvement. It is a breakthrough brought to the Query Store that SQL Server is not intended to provide. Tosska DB Ace can extract SQL from Query Store and tune it by generating new better plans in Query Store, users and then can force the new plan for the SQL without going through the program source code changes and programs test.

The best query plan is generated for the SQL statement in the Query Store
Extract SQL statement from the Query Store

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, resulting in an even worse query plan. It is difficult for developers to tune this kind of problem without a good tool. Tosska DB Ace 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 no longer exists in the buffer cache, a cold cache will significantly affect the performance of a SQL statement. A good-performance SQL for a hot cache may not be performing well in a cold cache environment. Experience developers will tune their SQL running well for both scenarios. Tosska DB Ace for SQL Server provides a handy function for users to benchmark SQL alternatives in both environments without crummy manual operations.

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 DB Ace 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 a 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 DB Ace 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 the overall impact of each new table’s indexes affecting each other in the query 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: 15 times faster A.I. SQL index recommendation for two tables at the same time
Before installing Tosska DB Ace Enterprise (DBAS™) for SQL Server®, please make sure your system meets the following minimum hardware ...
Click to view Tosska DB Ace Enterprise (DBAS™) for SQL Server 2.1.1 Release Notes ...
Click to view Tosska DB Ace Enterprise (DBAS™) for SQL Server 2.1.0 Release Notes ...