Release date: August 19, 2020
These release notes describe the new features, improvements, and fixed issues in Database Performance Analyzer 2020.2.1. They also provide information about upgrades and describe workarounds for known issues.
If you are looking for previous release notes for Database Performance Analyzer, see Previous Version documentation.
New features and improvements in DPA
DPA 2020.2.1 offers new features and improvements compared to previous releases of DPA.
Registering database instances with limited permissions
The following knowledge base articles provide instructions for registering database instances for monitoring without advanced permissions:
- Register an Amazon RDS Oracle database instance for DPA monitoring with reduced permissions
- Register an Amazon RDS SQL Server instance for DPA monitoring without the sysadmin role
- Register a Sybase database instance for DPA monitoring without the privileged user
- Register a SQL Server instance for DPA monitoring without the sysadmin role
- Register an Oracle database instance for DPA monitoring with reduced permissions
Preventing browser cookies from saving the username
A new advanced option called
LOGIN_FILL_USER can be used to prevent cookies from saving the username entered in the DPA login dialog. If you set the
LOGIN_FILL_USER option to
FALSE, the Username field is never automatically populated and the username is not stored in browser cookies. By default, this option is set to
TRUE and the
LOGIN_FILL_REPO_USER setting determines how the Username field on the DPA login dialog is populated.
Using the UTC time zone for log entries
You can configure DPA to record log entry timestamps using the UTC time zone instead of the time zone of the DPA server. For instructions, see Changing DPA to write logs using the UTC time zone.
Password encryption for Sybase monitored instances
You can encrypt the password that DPA uses to connect to a Sybase monitored database instance. To support password encryption for Sybase monitoring, the jConnect driver has to be used instead of the jTDS driver. By default, DPA uses the jTDS driver. For instructions, see Encrypt the password that DPA uses to connect to a monitored Sybase database instance.
New customer installation
How to upgrade
If you are upgrading from a previous version, use the following resources to plan and implement your upgrade:
- Use the DPA Installation and Upgrade Guide to help you plan and execute your upgrade.
- When you are ready, download the upgrade package from the SolarWinds Customer Portal.
Fixed issues in DPA 2020.2.1
DPA 2020.2.1 fixes the following issues.
|DPA 2020.2.1 includes security improvements.|
|By default, DPA no longer collects wait time for internal PostgreSQL processes, such as autovacuum. If you would like DPA to monitor wait time for these internal processes, set the advanced option
|When you are monitoring a PostgreSQL database instance, DPA issues the SQL statement
|When DPA is monitoring a SQL Server database instance running on server with multiple CPU cores, the Instance CPU Utilization resource metric displays the correct value.|
|DPA running on ESX servers with a compatibility setting of ESX 3.4 or 4|
Issue: If you attempt to run DPA on ESX servers as a virtual machine with a compatibility setting of ESX 3.4 or 4, DPA might not start. For additional information see this KB article.
Resolution/Work-around: Do one of the following:
|Creating the monitoring user when registering a MySQL 8.0 database instance|
Issue: For MySQL 8.0, the default authentication plug-in has changed from
|Adding a distributed AG to a server prevents DPA from monitoring non-distributed AGs on the server|
Issue: If DPA is monitoring non-distributed SQL Server Availability Groups (AGs) on a server and you add a distributed AG to the server, DPA stops monitoring the non-distributed AGs.
|Resolution/Work-around: Do not add a distributed AG to the server.|
|Validation of the LDAP/AD server host name fails because it doesn't match the subject of the certificate|
Issue: Java validates that the host name of the LDAP server matches the LDAP certificate by checking the subjectAlternativeName's dNSName fields of the certificate. If the validation fails, you will see the following error when you are configuring DPA to use AD/LDAP:
|Resolution/Work-around: Follow the instructions in this article to resolve the issue.|
|Real Time Sessions page|
Issue: When you are monitoring an Azure SQL Managed Instance (ASMI) that is registered via the public endpoint, some of the connections are closed after three minutes. If you turn the DPA monitor off, open the Real Time Sessions page, and then refresh the page after three to four minutes, the Real Time Sessions page displays the following SQL Server exception:
Resolution/Work-around: If you experience this issue, complete the following steps to configure DPA to recreate connections every three minutes:
|Microsoft reports incorrect metric values for SQL Server on Linux|
Issue: When you monitor a SQL Server 2017 database instance that runs on a Linux server:
When you monitor a SQL Server 2019 database instance that runs on a Linux server:
Microsoft reports these values.
|Resolution/Work-around: Disregard the values that are incorrect on your version of SQL Server. Upgrade to SQL Server 2019 to resolve the issue for the Instance CPU Utilization and O/S Memory Utilization resources.|
|Monitoring a database instance in the Oracle Public Cloud|
|Issue: When DPA is monitoring a database instance in the Oracle Public Cloud, it sometimes reports incorrect values.|
|Resolution/Work-around: DPA does not support monitoring database instances deployed in the Oracle Public Cloud. Use DPA to monitor supported database instance types.|
This version of Database Performance Analyzer deprecates the following platforms and features.
Deprecated platforms and features are still supported in the current release. However, they will be unsupported in a future release. Plan on upgrading deprecated platforms, and avoid using deprecated features.
|Repository database||Support for using Oracle 11.2 as the DPA repository database is deprecated. Oracle 11.2 is still supported as a repository database in the DPA 2020.2 release, but support will be removed in an upcoming release.|
Support for accessing DPA through a Microsoft Internet Explorer (IE) 11 browser or the legacy version of Microsoft Edge is deprecated. These browsers are still supported in the DPA 2020.2.1 release, but support will be removed in an upcoming release.
Upcoming releases will continue to support Chromium-based versions of Microsoft Edge.
End of life
|Version||EoL Announcement||EoE Effective Date||EoL Effective Date|
June 4, 2020 End-of-Life (EoL) announcement - Customers on DPA version 12.0 or earlier should begin transitioning to the latest version of DPA.
|September 2, 2020 End-of-Engineering (EoE) - Service releases, bug fixes, workarounds, and service packs for DPA version 12.0 or earlier will no longer actively be supported by SolarWinds.||September 2, 2021 End-of-Life (EoL) - SolarWinds will no longer provide technical support for DPA version 12.0 or earlier.|
June 4, 2020 End-of-Life (EoL) announcement - Customers on DPA version 11.1 or earlier should begin transitioning to the latest version of DPA.
|September 2, 2020 End-of-Engineering (EoE) - Service releases, bug fixes, workarounds, and service packs for DPA version 11.1 or earlier will no longer actively be supported by SolarWinds.||September 2, 2021 End-of-Life (EoL) - SolarWinds will no longer provide technical support for DPA version 11.1 or earlier.|
|DPA 11.0||November 5, 2019 End-of-Life (EoL) announcement - Customers on DPA version 11.0 or earlier should begin transitioning to the latest version of DPA.||March 7, 2020 End-of-Engineering (EoE) - Service releases, bug fixes, workarounds, and service packs for DPA version 11.0 or earlier will no longer actively be supported by SolarWinds.||March 7, 2021 End-of-Life (EoL) - SolarWinds will no longer provide technical support for DPA version 11.0 or earlier.|
See the End of Life Policy for information about SolarWinds product lifecycle phases. For supported versions and EoL announcements for all SolarWinds products, see Currently supported software versions.
© 2020 SolarWinds Worldwide, LLC. All rights reserved.
This document may not be reproduced by any means nor modified, decompiled, disassembled, published or distributed, in whole or in part, or translated to any electronic medium or other means without the prior written consent of SolarWinds. All right, title, and interest in and to the software, services, and documentation are and shall remain the exclusive property of SolarWinds, its affiliates, and/or its respective licensors.
SOLARWINDS DISCLAIMS ALL WARRANTIES, CONDITIONS, OR OTHER TERMS, EXPRESS OR IMPLIED, STATUTORY OR OTHERWISE, ON THE DOCUMENTATION, INCLUDING WITHOUT LIMITATION NONINFRINGEMENT, ACCURACY, COMPLETENESS, OR USEFULNESS OF ANY INFORMATION CONTAINED HEREIN. IN NO EVENT SHALL SOLARWINDS, ITS SUPPLIERS, NOR ITS LICENSORS BE LIABLE FOR ANY DAMAGES, WHETHER ARISING IN TORT, CONTRACT OR ANY OTHER LEGAL THEORY, EVEN IF SOLARWINDS HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
The SolarWinds, SolarWinds & Design, Orion, and THWACK trademarks are the exclusive property of SolarWinds Worldwide, LLC or its affiliates, are registered with the U.S. Patent and Trademark Office, and may be registered or pending registration in other countries. All other SolarWinds trademarks, service marks, and logos may be common law marks or are registered or pending registration. All other trademarks mentioned herein are used for identification purposes only and are trademarks of (and may be registered trademarks) of their respective companies.