DB Optimizer released

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.

Features

• 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.
• Single interface for all major DBMS.
• Graphical visualization of wait-time analysis.
• Continuous profiling.
• Batch tuning of DML statements, stored routines, entire SQL files.
• Hint injection.
• SQL rewrites.
• Robust diagnostics with execution statistics, profiling details, predicate analysis and explain plans.
• SQL IDE with code assist, error checking, debugging, and real-time quick fixes.
• Color-coded Index Analysis indicating index usage.
• SQL stress testing.

About Idera

Idera creates application and server management software for physical and virtual server platforms. They produce award-winning solutions for server backup, SQL Server administration. performance monitoring, recovery, security and compliance. More than 12,000 customers around the world, including many Fortune 1,000 enterprises and government agencies, rely on Idera products to keep their data backed up and protected and their servers optimized for performance.