Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Status
colourGreen
titleSQLWA-1164
The purge process needs to be rewritten for SQL Server architecture.

Status
colourGreen
titleSQLWA-1198
CPU spikes when SQLDM and SQLWA running on the same machine and it goes to 100%.

Status
colourGreen
titleSQLWA-1202
Remote SQL Server instances are showing question marks in SWA 1.7.2.

Status
colourGreen
titleSQLWA-1194
Unable to add Server due to different DB Server Collation settings

Status
colourGreen
titleSQLWA-1216
Support for SQL Server 2022.

Status
colourGreen
titleSQLWA-1217
SWA PMDB support on SQL Server 2022 instance.

1.7.2 New Features

No new features for this release.

1.7.2 Fixed Issues

Status
colourGreen
titleSQLWA-1154
Data randomly stops processing and is not available in SWA 1.7.0

Status
colourGreen
titleSQLWA-1150
Broken Wiki Links to be fixed.

Status
colourGreen
titleSQLWA-1144
Installation fails using the special character instance.

Status
colourGreen
titleSQLWA-1124
Able to monitor 2 servers while SWA is licensed for 1 server only.

Status
colourGreen
titleSQLWA-1116
SQLWA Repository DB credentials - including password, logged as plain text in the logs.

Status
colourGreen
titleSQLWA-1184
SQLWA 1.7.2 should be packaged with CWF 4.7

Status
colourGreen
titleSQLWA-1157
Run as administrator on exe file for the 1.7.1#16 the build number is showing 1.7.0

Status
colourGreen
titleSQLWA-1161
Log4j security vulnerability found in the Workload Analysis component.

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

Status
colourGreen
titleSQLWA-1119
SWAREPODB tables created in Master database.

Status
colourGreen
titleSQLWA-1135
Use default Admin account when installing SWA with the Idera Dashboard.

Status
colourGreen
titleSQLWA-1137
Install fails when account isn’t default.

Status
colourGreen
titleSQLWA-1140
Install issues with mix of windows and sa accounts.

Status
colourGreen
titleSQLWA-1147
SQLWA with IDERA Dashboard repository in the remote machine is not working.

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

Status
colourGreen
titleSQLWA-1108
Indexes are no longer missing from SQLWA Tables.

Status
colourGreen
titleSQLWA-1107
SQLWA log files are not growing out of control and filling up the C: drive anymore.

Status
colourGreen
titleSQLWA-1103
A wrong Program Name  no longer appears on the UAC wizard.

Status
colourGreen
titleSQLWA-1102
The ActiveMQ site has no longer a security concern, taking the default credentials.

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

Status
colourGreen
titleSQLWA-1047
 The Apache Tomcat default files security Vulnerabilities on WorkLoadAnalysis servers has been fixed.

Status
colourGreen
titleSQLWA-1035
SQL Workload Analysis is now connecting to instances with TLS 1.0 disabled and cyphers limited to AES 128 and above.

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.

 


Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse