DB Optimizer improves SQL Tuning

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.

Updates in XE4

• Identify Performance Bottlenecks Immediately - Database profiling provides a graphical visualization of wait-time analysis, making the SQL causing poor database performance easy to pinpoint.
• Tune SQL like a Pro - The SQL tuning wizard automatically suggests solutions and provides essential contexts for tuning SQL code. Color-coded Index Analysis shows used, not used or missing indexes and offers recommendations for optimum performance.
• Visually Tackle Complex SQL Queries - Visual SQL Tuning (VST) diagrams turn text-based SQL code into graphical SQL diagrams.
• Simulate Production Environments - Load testing verifies performance of existing and alternative SQL queries against the database.
• Become Proactive in Data Governance Compliance - DB Optimizer's ability to identify bottlenecks via database profiling, tune SQL and load test gives organizations an advantage in ensuring database optimization, uptime and availability.

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.