Do you feel like you're always
running after deadlines? |
Get ahead with the all-new Release 7
|
Server Studio™ & Sentinel™ — the principal suite of integrated system management tools for IBM Informix® data servers — has undergone a substantial upgrade and its brand new version its now available.
Release 7 of this industry-leading multi-platform graphical development and management environment provides DBAs and developers with an even richer collection of easy-to-use, proven tools to manage effectively and with ease complexities of the Informix data servers' infrastructure — from initial design and development, all the way through to production deployment and successful operational service. |
| All the vital Informix tools you need are in one place |
| This suite of highly intuitive tools provides wide-ranging functionality that enables database professionals improve efficiency of performing common database tasks such as: SQL development and debugging; schema management; configuration auditing and change management; data storage management and reorganization; security administration; rapid identification and remediation of performance bottlenecks and resources contention issues; server optimization and tuning; and whole lot more. |
| What's new and noteworthy in this release |
| Here are just a few of the noteworthy new features and capabilities in the Release 7 of Server Studio & Sentinel: |
| • |
Integrated query tuning: Brand new SQL Tuner is a powerful but easy-to-use tool that guides 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.
Integrated Index Adviser performs a thorough examination of SQL statements and presents index recommendations based on tables which are used by these statements.
To assist in query optimization, the New Query Result Difference Analyzer enables comparing data sets produced by two SQL SELECT statements executed from the same or multiple SQL Editor panes. |
| • |
Enhanced SQL code management: Revamped and much improved SQL Manager has enhanced code completion function, provides the ability to graph query result sets using multiple chart types (i.e. pie, bar, XY, etc.) and features the following new components:
— SQL Formatter improves formatting and beautifies individual SQL statements, SQL scripts, SPL stored procedures and triggers with wide ranging formatting options.
— Describe Object function provides the ability to get ‘in-place’ syntax for selected object in the SQL Editor (i.e. table, view or stored procedure syntax).
— SQL Templates Generator assists with auto creation of INSERT / UPDATE / SELECT / DELETE / CREATE code templates for the object whose name is selected in the SQL Editor (i.e. tables, views and synonyms).
— Related Data Links analyzes query result data sets based on identifiable primary / foreign keys in the SELECT predicate and provides links to navigate directly to the related data. |
| • |
Better data stores support: New Heatmaps facilities enable innovative multi-dimensional graphical analysis of storage resources and table activities. New DBSpace Data Fragmentation Analyzer assists in visualization of data distribution in dbspaces.
Enhanced Table Reorganization Wizard provides brand new algorithm that significantly improves performance and reduces resource consumption of table reorg operations. |
| • |
Robust configuration change management: Brand new Sentinel — Change Management Option edition streamlines database integrity management by: capturing periodic database schema configuration snapshots and retaining them in a built-in repository; providing robust facilities to detect changes from a baseline or between any two snapshots; as well as enabling easy roll-out, roll-back and recovery of lost or damaged database objects. |
| • |
Improved performance tracking and optimization: The real-time engine for collection of IDS operational parameters metrics in the Sentinel — Performance Edition has been revamped and made more efficient, along with the addition of: DBSPACE IS OFFLINE, CHUNK IS OFFLINE, ACTIVE THREADS, RATIO of THREADS IN READY QUEUE to ACTIVE THREADS, etc. parameters.
Enhanced Update Statistics Wizard provides a new algorithm that accounts for table structure and indexes, resulting in faster update statistics operations and improved access to tables' data. | |
Download Release 7 of Server Studio & Sentinel today and see for yourself what we've been busy working on for you. You'll be glad you did!
Sincerely,
AGS Informix Tools Team | |
 |
| Get your free trial today! |
Even if you've worked before with prior releases of Server Studio™ & Sentinel™, you really should check out cool new features and power in the all-new Release 7. Unlimited functionality will be available to you during the free 30-day evaluation period.
So, what are you waiting for? Download your copy here
|
| |
| Want to learn more? |
Review all the great tools and features in Server Studio here
|
See the enhanced Informix data server performance and the brand new configuration change management facilities provided by Sentinel here
|
| |
| Eligibility for Upgrades |
| Customers now using Release 6.1 – 6.5 of Server Studio & Sentinel without currently active Software Maintenance Contracts are encouraged to benefit from new capabilities provided in the all-new Release 7.0 by upgrading their licenses. |
 |
 | |
