IDERA SQL Query Tuner provides the following new features and fixed issues.
17.0.1 New features
Updated licensing
SQL Query Tuner 17.0.1 includes licensing updates to bring it into standard with other IDERA products.
Redesigned components
SQL Query Tuner 17.0.1 contains the following redesigned components for a better user experience:
- Main toolbar
- Data Source tab
- Project Explorer tab
- Main window tab right-hand mouse options
Enhanced SQL Server features
SQL Query Tuner 17.0.1 offers a number of SQL Server-related enhancements, including:
- The Tuning Statement window includes a drop-down list of schemas when viewing SQL Server databases.
- The SQL Query Tuner Profiler now properly displays SQL statement detail.
- Improved error messages.
17.0.1 Fixed issues
The following table includes customer-reported issues fixed in this release.
| Issue | Description | DBMS |
|---|---|---|
| OPT-5017 | SQL Editor problems do not appear in Problems view | SQL Server |
| OPT-5082 | Error log does not show errors reported by tuning session | All |
| OPT-5086 | SQL tuning session cost color preference not working | All |
| OPT-5087 | SQL tuning session cost color preference also applies to elapsed time | All |
| OPT-5088 | SQL tuning session stops if the elapsed time is longer than the original | All |
| OPT-5097 | SQL tuning session offers obvious selection criteria for picking winner | All |
| OPT-5098 | SQL tuning session should highlight # winners found and % improvement | All |
| OPT-5106 | Saving a tuning session does not persist/save user selections | All |
| OPT-5121 | “Tables/Views/Synonyms” are not getting resolved in SQL Server and Sybase when it exists in schema other than DBO | SQL Server, Sybase |
| OPT-5122 | Sybase: table name is getting resolved but not executed | Sybase |