Embarcadero DB Optimizer XE3.5 maximises database and application performance by enabling DBAs and developers to quickly discover, diagnose, and optimise poor-performing SQL. DB Optimizer eliminates performance bottlenecks by identifying data intensive or frequently executed queries, focusing on specific SQL statements through query statistics (CPU, I/O, wait times), and fine-tuning problematic statements.
Benchmark Factory for Databases helps you test your database environment and ensure your database is running at peak performance. Simulate users and tranactions, perform load testing on PL/SQL, T-SQL and stored procedures and use out-of-the-box industry standard benchmarks to help determine system throughput, database breaking points and gauge performance levels.
Benchmark Factory is available for Oracle, SQL Server, DB2, Sybase, MySQL and other databases via ODBC connectivity.
For a busy IT professional, it is nearly impossible to diagnose, troubleshoot and resolve every component affecting an Operating System (OS) performance using manual methods. Without a clear view of I/O and system activity, you learn of performance issues only after problems erupt.
With its unique graphical view of the OS internals, Quest® Spotlight® empowers you to quickly identify and eliminate bottlenecks in the OS environment. Displaying the real-time flow of data within your OS, Spotlight helps you to quickly identify and resolve performance problems.
Embarcadero's DB PowerStudio product line provides cost-effective database mangement and development tools for Oracle, SQL Server, Sybase ASE and IBM DB2. For each database management platform there are two editions - the Developer Edition enables SQL development with RapidSQL, performance tuning with DB Optimizer and change management capabilities with DB Change Manager. The DBA Edition includes DB Artisan XE for database management, DB Optimizer for performance tuning and advanced change management capabilities with DB Change Manager Enterprise.
Also available is DB PowerStudio XE which includes support for all available database platforms in one product.