The ever changing database management challenges
With the rapid changes of modern databases, database administrators and developers have to learn and manage new features provided by databases with short period of time. There is always a time gap between fully mastering new features and actually implementing the new features in production.
Easy-to-use AI enabled tools for SQL & database performance tuning
Tosska Technologies is a company that focuses in providing solutions for database and SQL related performance optimization and improvements. Our mission is to help users to smooth out the hurdle by our new technologies. Indeed Tosska is one of the very few companies in the world that focus in using artificial intelligence technology to solve various database performance problems. It is our goal to help our customers to reduce their hardware investment; increase their database applications service level and free up their human resources for more strategic activities with our innovative technologies.
Our Products
The Tosska DB Ace Enterprise Products Family
Tosska DB Ace Enterprise (DBAO™) for Oracle®
ALTERNATIVE WISDOM – Intelligent SQL tuning beyond human wisdom
Predicting, finding, and solving the problem with the right tool
Traditional monitor and SQL analysis tools in the market are focused on locating the high resource consumption SQL or screening SQL with basic SQL syntax and query plan analysis. Tosska DB Ace Enterprise is an innovative tool that not only shows you from the individual SQL execution behavior to the big picture of your overall database performance, but it also helps you to forecast the performance changes of a database in different environments. Furthermore, DB Ace Enterprise comes with a set of powerful A.I. SQL tuning functions to help you to solve SQL performance problems, it streamlines the process from performance prediction and problem identification to tuning resolution within a tightly integrated product.
Module Name
Functionality
Description
Inspect SQL – SQL Performance Tracker
Predicting problems
Performance Tracker helps you keep track of and forecast performance changes before and after the database environment changes such as update statistics, database migration, database upgrade, etc.
Inspect SQL
Finding problems
Analyze the database’s overall SQL healthiness, SQL syntax, query plan, and execution statistics to classify your SQL statements into different problematic areas.
Tune SQL
Solving problems
Use AI SQL Rewrite and Hints Injection and indexing technology to tune a SQL statement.
Tune SQL Plan
Solving problems
Use AI SQL Hints Injection technology to tune a SQL statement for Oracle’s SQL Patches and Plan Baselines. No source code changes are necessary to improve SQL statements.
Tune DB Link SQL
Solving problems
The Tune DB Link SQL module is embedded with tailored syntax rewrite rules and specific optimization hints injection for DB Link SQL statements in a distributed database environment.
Tune Top SQL
Finding & Solving problems
Extract high resource consumption SQL statements from Oracle AWR or SGA for SQL tuning in a batch.
Advise Global Indexes
Solving problems
Use the proprietary AI technique to recommend the best N indexes for a given set of SQL workloads captured from SGA or AWR.
Manage SQL Patches
Maintenance
Enable/disable and manage Oracle SQL Patches.
Manage SQL Plan Baselines
Maintenance
Enable/disable and manage Oracle SQL Plan Baselines.
Tosska DB Ace Enterprise (DBAP™) for PostgreSQL®
Stop Guessing. Start Solving. Get Your Slow Queries Running Faster – Automatically.
Tired of sluggish apps and endless SQL tuning? Tosska DB Ace is your automated performance engineer for PostgreSQL. It rewrites queries at the database level—no code changes needed.
Key Benefits
Fix Queries Instantly: Optimizes even packaged apps without source code edits.
Tosska DB Ace Enterprise (DBAS™) for SQL Server®
ALTERNATIVE WISDOM – Intelligent SQL tuning beyond human wisdom
What is Tosska DB Ace Enterprise 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.
Tosska DB Ace Enterprise (DBAM™) for MySQL ®
ALTERNATIVE WISDOM – Intelligent SQL tuning beyond human wisdom
What is Tosska DB Ace Enterprise for MySQL ?
Tosska DB Ace Enterprise is an innovative and groundbreaking tool designed for MySQL, offering comprehensive insights into your database performance. It allows you to monitor the individual SQL execution behavior while providing a broader view of your overall database performance. Equipped with powerful A.I.-powered SQL tuning functions, DB Ace Enterprise empowers users to optimize their SQL performance, whether or not source code modification is required.
Module Name
Description
Monitor SQL
Monitor SQL statements and performance in real-time within the Performance Schema, simultaneously across multiple databases.
Demo video: DBAM Monitor SQL Demo
Inspect SQL
Perform an analysis of the overall SQL health of the database and identify high workload SQL statements based on resource consumption in different categories.
Demo video: DBAM Inspect SQL Demo
Tune SQL
Utilize AI SQL Rewrite and Hints Injection techniques to optimize and fine-tune a SQL statement.
Demo video: DBAM Tune SQL Demo
Tune SQL for Rewriter Plugin
Leverage AI SQL tuning technology for the MySQL Rewriter Plugin to optimize and fine-tune a SQL statement without requiring any modifications to the source code.
Demo video: DBAM Tune Rewriter Demo
Not just another SQL Tuning tool !
Most SQL tuning products in the market aim to provide better query plan visualization, better statistics analysis, high cost query plan steps indication or even rule-of-thumb syntax recommendations. But very few of them can provide satisfactory tuning results directly. They require users to have in-depth SQL tuning knowledge to manually intervene the SQL tuning process amid their busy daily duties. In fact users are looking for one-button-solution tool that have all the required SQL tuning knowledge built-in and can tune a SQL statement automatically without the need of users’ intervention. If you are looking for such tools, these are the products you must look into !
World’s Leading A.I. SQL Rewrite technology for SQL
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 is quite expensive. Tosska A.I. SQL Rewrite Engine 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. 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.
Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle®
Targeted for the Oracle database, Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® 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.
They give users the ultimate SQL performance solution by just point and click without the need of user’s involvement. What you have to do is to input your problematic SQL statement into the product and press a button. You don’t have to do analysis, guessing or testing during the entire SQL tuning process. The improved SQL statement will be benchmarked with your original SQL statement side by side without suspicion.
World’s Leading A.I. SQL Rewrite technology for Oracle database
Tosska’s A.I. SQL Rewrite plus the A.I. Hints Injection Engine is the world’s leading machine SQL Tuning technology for Oracle database. It saves developer’s time to rewrite a problematic SQL by exploring the potenial best SQL syntax and hints injection that even an experienced developer cannot discover.
Plan Control feature to tune your SQL even if you don’t have the source code
Tosska SQL Tuning Expert Pro (TSE Pro™) also comes with an innovative Plan Control function that improves your SQL performance without touching your program source code. Users can even deploy different performance query plans for various sizes of production databases without the effort of keeping multiple versions of the program source, it is especially suitable for package application users who don’t own the source code of their applications. For application developers, a problematic SQL statement can be improved without going through the time-consuming unit test, integration test and program implementation required in software development cycle.
Intelligent Workload-Based Index Advisor
Apart from the intelligent SQL tuning features, a powerful indexes recommendation function is also provided in TSE Pro™ to help users to review and explore more potential indexes that are helpful but may be missing in current database schema.
It is an intelligent and cost-aware index advice engine that helps users to review their existing database schema if there are any new indexes which can help to improve a given SQL workload. The engine can handle up to thousands of SQL statements and give you a reasonable recommendation that even human experts cannot achieve.
Product features of TSE Pro™
Function
Description
Tune SQL – SQL Rewrite
SQL tuning by semantically equivalent SQL rewrite
Tune SQL – Hints Injection
SQL tuning by query hints injection
Tune SQL – Single SQL Index Recommendation
SQL tuning by A.I. Index advisor for a specific SQL
Plan Control
SQL tuning with no need to change source code
Tune Top SQLs
Find and tune high resource consumption SQL from SGA or AWR
Advise Indexes
Workload based indexes advisor for up to thousands of SQL as a whole at the same time
Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss®
Targeted for the openGauss database, Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss® is a complete SQL tuning solution that provides openGauss Hints, SQL syntax rewrite and index recommendation to maximize the performance of an openGauss SQL without compromise in any specific feature’s limitation.
Machine tuning for openGauss SQL statements
Due to the extensive number of possible permutations for openGauss Hints combinations and rewrites, it becomes impractical for a human expert to manually explore all options, especially for complex SQL statements. Even after numerous trials and errors, there is no guarantee that a DBA or developer can find the optimal solution. With our proprietary A.I. based Machine Tuning Engine, TSEG Pro™ emulates the process of SQL tuning performed by human experts and explores various combinations of openGauss Hints and syntax rewrite for a given SQL statement, aiming to enhance its execution speed.
Specialized tuning techniques for Cursor SQL and Dynamic SQL
Cursor SQL and dynamic SQL are two distinct types of SQL statements that require specialized tuning techniques to optimize their performance. Developers may encounter challenges when attempting to tune Cursor SQL within a dynamic SQL environment, such as openGauss Data Studio.
Tosska SQL Tuning Expert offers a unique feature that specifically addresses Cursor SQL tuning. By selecting the Cursor SQL option, the entire tuning process is tailored to a cursor environment, from query plan generation to SQL execution. This ensures that the resulting optimized SQL alternative is best suited for cursor SQL execution within your application, leading to improved overall application performance and efficiency.
The screenshot demonstrates how Tosska SQL Tuning Expert can effortlessly explore thousands of SQL alternatives in just a few minutes, a task that would typically require months of effort from a human expert.
Following the benchmarking of partial or all SQL alternative execution plans, the optimal SQL alternative will be presented alongside the original SQL statement on the screen. This entire process is fully automated, eliminating the requirement for user intervention. The result represents the best solution out of the thousands of potential execution plans that openGauss can generate for the given SQL statement. This exhaustive search and testing process is beyond the capabilities of a human expert.
Uncompromised SQL index tuning for a SQL statement
If you have mission-critical SQL queries and statements that you are dissatisfied with the syntax rewrites, you could enhance and improve their performance by adding indexes using the AI-driven index tuning features of Tosska SQL Tuning Expert Pro without any compromises. Our recommended indexes feature offers multiple sets of indexes for you to test with your SQL statements, enabling you to uncover the optimal performance capabilities of your SQL queries.
Users can determine the time allotted to the index search process, the maximum number of indexes in each recommended index set, and the maximum columns in each suggested composite index and can fine-tune the data sampling rate to optimize the engine’s speed for improved performance in different environments.
Tosska Technologies Limited is a young and energetic company that provides intelligent database tuning tools to help our customers to optimize their databases performance to the maximum within the current database and hardware limitation.
With the rapid changes of modern databases, database administrators and developers have to learn and manage new features provided by databases with short period of time, there is always a time gap between fully mastering new features and actually implementing the new features in production.
Our mission is to help users to smooth out the hurdle by our new technologies. Furthermore, Tosska is one of the very few companies in the world that focuses on using artificial intelligence technology to solve various database performance problems. It is our goal to help our customers to reduce their hardware investment; increase their database applications service level and free up their human resources for more strategic activities with our innovative technologies.
Tosska has a very strong technical team. Our CTO has over twenty year experiences in the Artificial Intelligent software development field supported by a development team with solid database management related software development experience in fortune 500 international corporations.
