Advanced analysis and faster SQL tuning for DBAs. Developers tune with confidence. Everyone wins! The latest release of DB Optimizer delivers with new features that make easier than ever to optimize your SQL code for top performance. Now DBAs can go beyond injections and SQL rewrites and dig into advanced index analysis and explore design flaws. And developers can confidently own more of the SQL performance tuning process knowing the code they pass to the QA engineer and DBA is more fully optimized. DB Optimizer offers: Graphical visualization of wait-time analysis Continuous profiling Batch…

DB Optimizer XE Overview and Video Demo 14-minute overview and video demo of DB Optimizer XE’s core capabilities. DB Optimizer XE is a database performance tuning solution that includes support for Oracle, IBM DB2, Microsoft SQL Server and Sybase ASE. In this video, you’ll see Kyle Hailey identify where the load on the database is coming from and then tune it using Visual SQL Tuning. DB Optimizer XE Enterprise 4-minute overview of how DB Optimizer XE Enterprise, which includes DB Performance Center XE, alerts you when trouble strikes one of your critical databases— and how you can…

Database Administrators (DBAs) and developers are under increasing pressure to maintain the highest levels of database and application performance. They must balance customer satisfaction and productivity with rising costs and shrinking budgets. Throwing more hardware or resources at the problem is no longer an option. Neither are outages or delays. Optimization tools are needed to ensure that poor-performing code never reaches the production environment - where it is significantly more costly to correct bad SQL or application code. Development and QA It is the developer's responsibility to prevent poor-performing SQL code from reaching production in the first place. DB…

Do you need to write, debug, and tune database logic more efficiently and for higher performance? Take a look at Rapid SQL XE2, a heterogeneous SQL IDE that helps developers and DBAs produce high quality SQL code faster. More Related Products Embarcadero® J Optimizer™Comprehensive environment for optimizing application performance and managing application quality. Embarcadero® Performance Center™24/7 database performance monitoring for maximum database availability and performance. Rapid SQL® XE2A heterogeneous SQL IDE that helps developers and DBAs produce high quality SQL code faster DBArtisan® XE2The leading heterogeneous database administration tool helps DBA's maximize availability, performance, and security. Embarcadero® Change…

Along with enhancements to the core product, DB Optimizer XE2 includes all database platforms supported in one price, one license; Embarcadero® ToolCloud™ centralized license and deployment features; and InstantOn™ for running tools without installation. Enhanced SQL Visual Tuning (VST) Diagrams Visual SQL Tuning (VST) diagrams have been enhanced to include table statistics. The VST diagram now can display table sizes, the sizes of the joins between tables in the query, and the percentage of rows returned, on every table that has a predicate filter. These statistics allow the developer to immediately see any bottlenecks or potential issues as…

DB Optimizer XE2 Installation Guide View PDF DB Optimizer XE2 New Features Guide View PDF DB Optimizer XE2 User Guide View PDF DB Optimizer XE2 Evaluation Guide View PDF

Running our company monthly invoices were taking upwards of three hours to run and sometimes the SQL server would stop processing the invoices. We needed to find out what was causing the slow down as fast as possible and fix it. DB Optimizer allowed us to see that the indexes were not optimized, memory was being squeezed and the I/O subsystem was not the best fit. This allowed our team to tackle the three major issues all at the same time without going down a wrong path. Without DB Optimizer we would have had to use numerous tools…

32 and 64-bit versions of Microsoft Windows 2003, XP, Vista and Windows 7 Red Hat Enterprise Linux 5.0 (32 bit), or SUSE Linux Enterprise Server 10 (32 bit) Sun Java 2 Standard Edition 5.0 Update 11 for Microsoft Windows or Linux: Sun Java 2 Standard Edition 5.0 Update 11 for Linux x86 1024 MB memory 500 MB disk space

DB Optimizer supports SQL execution and SQL tuning on the following DBMS versions running on Linux® - and Windows NT® - based servers: Oracle® 8i - 11g Sybase® 12.5 - 15.0 IBM® DB2® for LUW 8.0 - 9.5 Microsoft SQL Server 2000, 2005, and 2008 JDBC (execution only) DB Optimizer supports SQL profiling on the following DBMS versions running on Linux® - and Windows NT® - based servers: Oracle® 8i - 11g Sybase® 12.5.0.3 - 15.0.3 IBM® DB2® for LUW 8.2 - 9.5 Microsoft SQL Server 2000 SP3, 2005, and 2008 …