About Us

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 SQL Tuning Expert Products Family

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 for Oracle® (TSE™ and TSE Pro™) version 4

 

 
Targeted for the Oracle database, Tosska SQL Tuning Expert (TSE™) for Oracle® and Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® are complete SQL tuning solutions that provide 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 feature comparison of TSE Pro™ and TSE™

View Details | Free Download – TSE™ / TSE Pro™ | Buy License – TSE™ / TSE Pro™

 
Tosska SQL Tuning Expert (TSEM™) for MySQL®
As a member of the TSE product family, TSEM™ provides all the automatic A.I. machine tuning capability of TSE but tailors for the MySQL database. It is a one-button-solution tool that can tune MySQL SQL statement automatically without the need of your intervention. 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.

Probably the World’s ONLY A.I.-based SQL Rewrite solution for MySQL database
It not only saves developer’s time to rewrite a problematic SQL statement to make it faster, but also explores the potential best SQL syntax that even an experienced developer cannot discover. Tosska A.I. rewritten SQL syntax can also work with our Hints-injection algorithm to further explore more potential query plans that even most experienced developers cannot achieve.
A 100 times faster SQL rewrite is generated on the right hand side.

Tosska proprietary Tree Plan format for your easy understanding
Tosska SQL Tuning Expert (TSEM™) for MySQL® has a market leading explain plan function for MySQL. The proprietary Tree Plan format provides rich statistics information like what is provided by Tubular Explain from MySQL, as well as a hierarchical structure like what is displaying in visual plan. The beauty is that all such information can be displayed in a small window for easy reading.

Tosska Tree Plan

View Details | Free Download | Buy License


 

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

There are very limited SQL tuning tools for SQL Server database available in the market, not to mention one that can provide one-button automated direct SQL tuning results. Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server® is a complete SQL Server 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, without the need of your intervention. You can just sit back, relax, and wait for the best SQL alternative to come up on your screen.

World’s Leading A.I. SQL Rewrite technology for SQL Server database
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. Tosska A.I. rewritten SQL syntax can also work with our Hints-injection algorithm to further explore more potential query plans that even most experienced developers cannot achieve.

World’s Leading SQL Server A.I. SQL Tuning Tool for SET ROWCOUNT N
Many people do not know that the Set Rowcount N setting can affect the SQL’s query plan and some SQLs’ performance may be degraded and resulted in an even worse query plan. Tosska SQL Tuning Expert for SQL Server is probably the first tool that can solve this problem automatically with our A.I. engine.

Powerful Cold Cache SQL Tuning for Infrequent Executed SQL Statements
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. Tosska SQL Tuning Expert for SQL Server provides a handy function for users to benchmark SQL alternatives in both environments without complicated manual operations.

View Details | Free Download | Buy License

SQL index tuning that exceeds human capabilities
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.

Explore your SQL Server’s potential ability before considering a hardware upgrade
There are situations where some SQL statements cannot be tuned by syntax rewrite, hints injection, and all necessary indexes are built. But before you think about hardware upgrade, please don’t undermine your SQL Server’s SQL optimizer which can provide you with the ultimate performance solution by providing it with a set of proper new indexes. Tosska SQL Tuning Expert Pro for SQL Server is in-built with an A.I. engine to recommend indexes for multiple tables at the same time for a SQL statement. The engine so powerful that it can consider how each new table’s indexes affect each other in the query plan. SQL Server’s SQL optimizer can then 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 consider a hardware upgrade.

View Details | Free Download | Buy License

Our Company

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.

News


Click to view Tosska SQL Tuning Expert (TSEM™) for MySQL 2.3.2 Release Notes

query performance tuning

Click to view Tosska SQL Tuning Expert (TSE™) 4.6.0 Release Notes

download free sql server

Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 4.6.0 Release Notes

sql server performance tuning

Click to view Tosska SQL Tuning Expert (TSE™) 4.5.1 Release Notes

download free sql server

Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 4.5.1 Release Notes

Click to view Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server 2.1.1 Release Notes

Click to view Tosska SQL Tuning Expert (TSES™) for SQL Server 1.5.1 Release Notes

download free sql server

Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 4.5.0 Release Notes

sql server performance tuning

Click to view Tosska SQL Tuning Expert (TSE™) 4.5.0 Release Notes

Click to view Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server 2.1.0 Release Notes