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.3
DB Optimizer 18.3
Improves profiling session capability which alerts users to potentially problematic SQL ahead of time.
DB Optimizer 18.2
DB Optimizer 18.2
Adds support for Microsoft Windows 11.
DB Optimizer for SQL Server 18.1
DB Optimizer for SQL Server 18.1
Adds the ability to open multiple files from the command line.
DB Optimizer 17.1
DB Optimizer 17.1
Improves real-time syntax checking and code formatting.
DB Optimizer 17.0.4
DB Optimizer 17.0.4
Adds support for Oracle 18c and 19c, Sybase 16.0 and SQL Server 2019 databases.
DB Optimizer for SQL Server 17
DB Optimizer for SQL Server 17
Adds SQL Server 2017 database and Windows Server 2016 OS support.

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.

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

Recent Awards

PublisherPublisherPublisher