DB Optimizer Community

Welcome to the DB Optimizer Community!

Embarcadero DB Optimizer lets you quickly discover, diagnose, and optimize poor-performing SQL. By discovering data-intensive or frequently executed queries, focusing in on specific SQL statements through query statistics (i.e., CPU, I/O, wait times), and optimizing any problematic statements, DB Optimizer eliminates performance bottlenecks.

  • Eliminate performance bottlenecks in production databases and applications
  • Prevent poor-performing SQL from reaching production
  • Develop, test, profile, and tune SQL in a single easy-to-use IDE

Articles

Sort by:
DateTitleAuthorType
29 Apr 2011 Building and Tuning SQL Server Applications
Webinar on demand and special offers
Tim DelChiaro Video
21 Jan 2011 Finding & Fixing Performance Problems in a Complex Application & Database System
Alarm SMS messages and emails are being sent by the performance monitoring system to the production DBA team and the development team alerting everyone that the latest release of a critical business application and the underlying databases are grinding to a halt. The developers, QA team, and DBAs all point fingers at each other. The developers say "My code is perfect. It passed all of the unit, system and load tests". The QA team says "we tested and certified the code, the SQL, and the database". The DBAs say “the production servers are configured according to the specifications and have all of the latest updates.” Has this ever happened to you?
Calvin Tang Video
18 May 2010 Using the DB Optimizer Plug-in for RAD Studio, Delphi and C++Builder 2010
Access DB Optimizer functionality from within the Delphi and C++Builder IDEs
Tim DelChiaro Video
16 Oct 2009 SQL Tuning & Analysis | DB Optimizer 2.0
Embarcadero DB Optimizer maximizes database and application performance by enabling DBAs and developers to quickly discover, diagnose, and optimize poor-performing SQL.
Michael Findling Video
18 Aug 2009 Video: Identify and Fix SQL Performance Bottlenecks with DB Optimizer
Quickly discover, diagnose, and optimize poor-performing SQL
Tim DelChiaro Video
20 Mar 2009 DB Optimizer Short Demonstrations
Short demonstrations outlining best practices for profiling and tuning SQL using DB Optimizer
Greg Nerpouni Video
20 Feb 2009 DB Optimizer 1.5 main work flow video
quick 7 minute video on using Profiler and Tuner to optimize a database
Kyle Hailey Video

Server Response from: ETNASC04