1.6.6 Fixed Issues

SQLWA-890 The error 'SQLWA is unable to connect to the SQL Server instance. Please verify that the instance name is spelt correctly' is no longer displaying when adding new instances after upgrading SQL Workload Analysis.

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

SQLWA-991 The Home and Administration tabs are loading and displaying data properly.

SQLWA-992 SQL Workload Analysis is no longer prompting exceptions when adding instances

SQLWA-993 SQL Workload Analysis now correctly displays the details of the added instance in the Finish screen of the Add Instances wizard.

SQLWA-994 SQL Workload Analysis now correctly finishes its installation process.

SQLWA-1000 SQL Workload Analysis now correctly displays the tool tips for the vertical and horizontal bars.

SQLWA-1001 The license details are correctly displaying under the Manage License option.

SQLWA-1002 The data now correctly loads when clicking the "View execution plan" button.

1.6.5 New Features

• SQL Workload Analysis services can be configured to use non-default port numbers.

1.6.5 Fixed Issues

SQLWA-538 SQL Workload Analysis now correctly parses collected decimal numbers using comma instead of a decimal point

SQLWA-647 Upon removing a monitored instance, SQL Workload Analysis will promptly purge data related to the instance. Previously, SQL Workload Analysis would retain the data until it is fully groomed from the repository based on the grooming schedule.

SQLWA-800 SQL Workload Analysis now correctly adds new monitored instances based on the number of available licenses within the license key.

SQLWA-889 SQLWA now correctly registers instances after performing an upgrade.

1.6.4 New Features

No new features for this release.

1.6.4 Fixed Issues

• SQL Workload Analysis now correctly collects data for the monitored instances
• The SQL Workload Analysis wizard no longer becomes unresponsive when adding instances
• SQL Workload Analysis now correctly displays data for the monitored servers
• The Administration options: "Add Instances", "Manage Instances", and "Manager License" are now displaying correctly
• SQL Workload Analysis is no longer stopping the collection of data randomly
• SQL Workload Analysis widgets are now loading properly
• A fix has been applied to correct the displayed error: "I/O Error: DB server closed connection"
• Accounts that are part of an active directory group are no longer reporting errors when accessing the IDERA Dashboard
• The CPU utilization is no longer high or constantly rising up when running SQL Workload Analysis
• SQL Workload Analysis now correctly monitors and re-registers instances
• SQL Workload Analysis now correctly removes instances
• SQL Workload Analysis now correctly processes and displays collected data

1.6.2 New Features

• SQL Workload Analysis 1.6.2 includes a new licensing library, which only affects products with expiring licenses.

1.6.2 Fixed Issues

• SQL Workload Analysis is no longer displaying errors when viewing execution plans.
• SQL Workload Analysis is no longer having issues when installed with non-default Dashboard locations

1.6.1 New Features

• SQL Workload Analysis allows you to configure the storage location for the SQLWA database and the message queue files.
• New widget "Top SQL Stored Procedure" with drill-down capability.
• Launch SQL Diagnostic Manager in context to specific time-range from SQL Workload Analysis.

1.6.1 Fixed Issues

• SQL Workload Analysis is collecting information normally for its respective analysis.
• The “Login Failed. The login is from an untrusted domain and cannot be used with Windows authentication” message is no longer displaying when registering instances in SQL Workload Analysis.
• The error "Reason: ERROR: 22001: value too long for type character varying(40)) is no longer displying when entering credentials during installation.

1.5 New features

• Integration with the IDERA Dashboard
• Unified installer for both products: IDERA Dashboard & SQL Workload Analysis
• Drill-down capability for top programs, top machines, and top logins
• Add new instances using existing list of registered instances in the IDERA Dashboard

1.5 Fixed Issues

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