DB Optimizer XE
Embarcadero® DB Optimizer™ maximizes database and application performance by enabling DBAs and developers to quickly discover, diagnose, and optimize 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.
- Optimize SQL performance throughout the development lifecycle
- Eliminate performance bottlenecks in production databases and applications
- Develop, test, profile, and tune SQL in a single, easy-to-use IDE
As an agentless desktop tool, DB Optimizer is easy to install and point at any database to quickly detect problematic SQL statements. Continuous profiling monitors performance within a configurable span of time to help verify the effects of tuned statements. Profiling snapshots can be saved and shared between developers, QA, and DBAs for focused diagnosis and increased productivity. DB Optimizer supports IBM® DB2® for LUW, Microsoft® SQL Server, Oracle®, and Sybase®.
Key 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
- Centralized license management and tool deployment with Embarcadero ToolCloud
Please click here to get all the information you need about DB Optimizer XE, including webinars, datasheets, white papers, etc.
Article by Kyle Hailey:
Oracle database performance tips tricks and links Data visualization techniques SQL Tuning Information on Embarcadero's DB Optimizer product
Read this full article at Kyle's blog: http://db-optimizer.blogspot.com/