DB Optimizer XE2


Version: 3.0
Size:
N/A
Requirements:
No special requirements
Price:
N/A
System:
Windows 7/Vista/2003/XP
Rating:
4.4
License:
Shareware

Description - DB Optimizer XE2



Embarcadero DB Optimizer XE2 is a heterogeneous tool that maximizes database and application performance by quickly discovering, diagnosing, and optimizing poor-performing SQL. DB Optimizer XE2 empowers DBAs and developers to: Eliminate performance bottlenecks by visually profiling key metrics inside the database (CPU, I/O, wait times) Relate resource utilization to specific queries, and helping to visually tune problematic SQL. Eliminate performance bottlenecks in production databases and applications Develop, test, profile, and tune SQL performance with a single, easy-to-use IDE across all databases Features: *Graphical visualization of wait-time Analysis *Continuous profiling *Batch tuning of DML statements, stored routines, entire SQL files *Hint injection *SQL rewrites *Visual SQL Tuning (VST) Diagrams *Advanced index analysis with recommendations *Robust reporting with Execution statistics, profiling Details, predicate analysis and explain plans *SQL stress testing *SQL IDE with code assist, error checking, debugging and real-time quick fixes



More in Database Management-DB Optimizer XE2

Analysis Databases Performance Bottlenecks