DB Optimizer for SQL Server

DB Optimizer quickly discovers, diagnoses and optimizes poor performing SQL. DB Optimizer empowers DBAs and developers to optimize SQL performance throughout the development lifecycle and eliminate performance bottlenecks in production databases and applications. Use DB Optimizer to develop, test, profile and tune SQL in a single, easy-to-use IDE. DB Optimizer tunes and profiles SQL code, and tests SQL code in simulated production environments for multiple relational database platforms.

DB Optimizer helps production DBAs quickly profile databases to identify and correct the SQL causing performance bottlenecks. Key features in DB Optimizer include:

  • Ability to stream profiling data into a central repository.
  • Determine resource usage for stored procedures with visibility into underlying SQL usage.
  • Visual SQL tuning diagram displaying indexes and constraints, enhanced with table statistics.

DB Optimizer Features

  • Graphical visualization of wait-time analysis.
  • Continuous profiling...

Latest News

DB Optimizer 18.4
DB Optimizer 18.4
May 25, 2023New Version
Now includes native Git version control.
DB Optimizer 18.3
DB Optimizer 18.3
December 14, 2022New Version
Improves profiling session capability which alerts users to potentially problematic SQL ahead of time.
DB Optimizer 18.2
DB Optimizer 18.2
July 21, 2022New Version
Adds support for Microsoft Windows 11.
DB Optimizer for SQL Server 18.1
DB Optimizer for SQL Server 18.1
April 22, 2022New Version
Adds the ability to open multiple files from the command line.
DB Optimizer 17.1
DB Optimizer 17.1
October 19, 2020New Version
Improves real-time syntax checking and code formatting.
DB Optimizer 17.0.4
DB Optimizer 17.0.4
August 29, 2019New Version
Adds support for Oracle 18c and 19c, Sybase 16.0 and SQL Server 2019 databases.

Prices from: $ 569.14

Licensing and Deployment Solutions: The Workstation option is perfect for individual users; while the network-based named and concurrent licensing options provide a flexible, cost-effective solution...

Got a Question?

Live Chat with our IDERA licensing specialists now.

As official and authorized distributors, ComponentSource supplies you with legitimate licenses directly from IDERA.
Supported Database Platforms
  • Microsoft SQL Server 2022, 2019, 2017, 2016, 2014 SP2, 2014, 2012, 2008

Recent Awards