IDERA SQL Query Tuner provides the following new features and fixed issues.
17.0.4 New features
Updated SQL Server support
SQL Query Tuner 17.0.4 supports SQL Server 2019 as tested against community technology preview 3.2.
17.0.3 New features
There are no new features in this release. This release does include a number of fixed issues that you may review in the Fixed issues section.
17.0.2 New features
Updated version
SQL Query Tuner 17.0.2 is simply an update to the version number.
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.4 Fixed issues
There are no fixed issues in this release.
17.0.3 Fixed issues
| Issue | Description | DBMS |
|---|---|---|
| OPT-5269 | Trying to view "Using DB Optimizer" web page causes an error | All |
| OPT-5270 | Optimizer not collecting "sql_statement" information | Sybase ASE |
| OPT-5273 | Data source name cannot exceed 30 characters in CM and DBO | All |
| OPT-5274 | Install/config error: Driver not configured for integrated authentication | SQL Server |
17.0.2 Fixed issues
There are no fixed issues in this release.
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 |