Page History

1.7.3 New Features

SWA 1.7.3 provides a complete revamp of the grooming (purge) process which sees a reduction in the size of the SWA repository and the size of the SQL Transaction Log. This prevents the SWA repository from growing too large and the SQL Transaction Log from growing out of control. 

SWA 1.7.3 is also compatible with the latest IDERA web access framework version allowing improved web access experience.

1.7.3 Fixed Issues

1.7.2 New Features

No new features for this release.

1.7.2 Fixed Issues

1.7.1 New Features

In SQLWA version 1.7.1, upgrade support has been added from the 1.7.0 version. Although SQLWA 1.7.1 can be installed in more than one way, you can ONLY upgrade to 1.7.1 version from 1.7.0 version, but not from the other previous versions.

SQLWA 1.7.1 can be installed in the following ways, depending on the currently installed 1.7.0 version:

• If this is the first time you are installing SQLWA, install version 1.7.1 as described in the Clean installation of the SQLWA Framework section of the  SQLWA Installation guide.
• If you have installed the 1.7.0 version already and you want to upgrade it to the version 1.7.1, follow the specific  Upgrade instructions.

1.7.1 Fixed Issues

1.7.0 New Features

Support has been added for the following components:

1. Collector re-architecture has been done to separate the services for SQL authentication, monitoring instances for user defined number of services.
2. Upgraded the active MQ to the version 5.16.3 and tomcat server versions to 9.0.52 resolve security and EOL issues.
3. Implement a solution for rolling up fast growing tables such as PW_SQPS_SQL_STATISTIC_H.

1.7.0 Fixed Issues

1.6.8 New Features

• SQL Workload Analysis now uses SQL Server repository databases for its PMDB.
• SQL Workload Analysis can now perform a connectivity test to monitored instances.

1.6.8 Fixed Issues

1.6.7 New Features

No new features for this release.

1.6.7 Fixed Issues

SQLWA-529 SQL Workload Analysis is no longer stopping collecting and displaying data.

SQLWA-892 The Postgress size is no longer causing high memory usage in SQL Workload Analysis.

SQLWA-1030 The SQLWA collection service is no longer stopping unexpectedly.

SQLWA-1054 SQLWA now correctly collects data and the added instances are showing their correct status.

SQLWA-1031 A SQLWA process is no longer causing the SQL Server session blocking.

SQLWA-1033 SQLWA now correctly processes data that was randomly stopping under certain conditions.

SQLWA-1036 The Postgress Purge is no longer causing deadlocks or stalling the data collection in SQLWA.

SQLWA-1048 The idera_swa_postgresql service no longer needs to be restarted to correctly show SQLWA in the IDERA Dashboard.

1.6.6 New Features

• SQL Workload Analysis upgraded all critical components to the latest compatible releases.

...

• SWA no longer requires a server reboot, when from time to time, stops collecting data.