The following lists only some of the key new features and capabilities of the Server Studio¢â and Sentinel¢â Release 7. For detailed review of all new features and capabilities, please visit the Beta Program Site >>
- The brand new SQL Tuner is an easy-to-use tool that allows database professionals to create and tune database code to optimize the efficiency and speed of the database. It increases database performance by not only helping to find and fix poorly-written code, but also aids in building fast and accurate SQL code the first time around. SQL Tuner offers powerful but easy-to-use facilities with an intuitive graphical interface that guide database professionals through the complex process of tuning the code by helping locate bottlenecks and automatically suggesting more optimal SQL cases to correct performance deficiencies.
- New SQL Formatter component formats and beautifies individual Informix SQL statements, SQL scripts and SPL stored procedures and triggers with many formatting options.
- New Query Result Difference Analyzer component allows comparing results of two SQL SELECT statements executed from the same or multiple SQL editors.
- Version Control Snapshots ("VCS") is a brand new innovative set of features designed to increase productivity and convenience in managing database configuration changes when working alone or collaborating with others.
- New Heatmaps component allows performing graphical two-dimensional analysis of storage, table activities and user session activities.
- Enhanced Table Reorganization wizard provides new algorithm that allows to significantly improve performance of reorg operations.
- Enhanced Update Statistics wizard provides advanced algorithm that takes into account table structure and indexes allowing faster Update Statistics operations and improved access to tables' data.
- New DBSpace Data Fragmentation Viewer visualizes data distribution in dbspaces.
- Significantly enhanced SQL Editor
- Support for additional IDS performance metrics, such as DBSPACE IS OFFLINE, CHUNK IS OFFLINE, ACTIVE THREADS, RATIO of THREADS IN READY QUEUE to ACTIVE THREADS, etc.
Our goal is to have a well-targeted group of dedicated testers willing to participate actively and provide useful feedback to our development team. Your feedback will be critical to the ultimate success of our products.
Thank you for your attention.
Sincerely, AGS Beta Program Team |