IDERA® DB Optimizer is an automated SQL optimization tool that improves the performance of databases and applications by quickly detecting, diagnosing, and optimizing low-performing SQL code. DB Optimizer provides developers and database administrators with the ability to visually profile key database indicators, identify specific resource utilization features, and visually optimize SQL code, which makes it possible to correct problem areas of code that limit performance.


Instantly identify performance bottlenecks.
Database profiling creates a graphical analysis of latency analysis. With it, it is very easy to detect SQL code that degrades database performance. In the process of continuous profiling, the entire data source is monitored within a custom time interval. Execution plans help to better understand how the SQL code will be executed and what the performance cost is made of. Built-in reporting tools allow you to share information gathered through the profiling process.
Add. information:
Professional SQL code optimization
The SQL Optimization Wizard automatically provides solutions and provides the necessary context for optimizing SQL code. The color-coding index analysis tool displays used, unused, and missing indexes and provides recommendations for improving performance. Variant generation tool optimizes database queries. It formulates all possible options and finds among them the best alternative for a specific SQL statement using automatic rewriting of SQL code and insert prompts.
Visual configuration of complex SQL queries
Unique SQL Visual Optimization (VST) charts transform text-based SQL code into graphical SQL diagrams. This approach helps administrators and database developers understand how SQL statements affect the database. The Visual SQL Tuning Visual Optimization (VST) diagram shows indexes and constraints in tables and views using table statistics, as well as join operations used in SQL statements, such as direct and implied Cartesian products and many-to-many relationships.
Workload Modeling
Load testing provides performance testing of existing and alternative SQL queries to the database. You can set up requests for mass parallel execution, as well as test their responsiveness in a simulated production environment without risky actual testing under production conditions.
Ensure data management standards are met in advance.
Using DB Optimizer for database profiling and determining bottlenecks, optimizing SQL code and performing load testing, organizations can achieve guaranteed high levels of efficiency, availability and availability of databases. Thanks to this tool, you will be able to identify potential performance problems in advance and ensure compliance with performance and availability standards in data management.


Version: 17.0.1 Build: 201803201712
Developer: IDERA
Developer website: www.idera.com
Digit capacity: 32bit, 64bit
Interface Language: English
Tabletka: present
System requirements:
1 GHz or faster processor
3 GB RAM
1 GB of free disk space
Display 1024 x 768
Supported operating systems:
Windows 10, Windows 8.1, Windows 8, Windows 7 (32-bit and 64-bit)
Windows Server 2008 SP1 & 2008 R2 (32-bit and 64-bit)
Windows Server 2012 & 2012 R2
Windows Server 2016