DPA 2021.1 Release Notes
Release date: January 19, 2021
These release notes were last updated on May 3, 2021.
These release notes describe the new features, improvements, and fixed issues in Database Performance Analyzer 2021.1. (The full build number is 2021.1.775.) They also provide information about upgrades and describe workarounds for known issues.
Other resources:
If you are looking for previous release notes for Database Performance Analyzer, see Previous Version documentation.
New features and improvements in DPA
DPA 2021.1 offers new features and improvements compared to previous releases of DPA.
New code-signing certificate
DPA is signed with a new digital code-signing certificate.
For more information on the additional steps SolarWinds is taking to improve our security posture and policies please reference this blog by SolarWinds President and CEO Sudhakar Ramakrishna.
Find SQL
The DPA Trends charts display SQL statements with the highest wait times. But in some cases you want to analyze a SQL statement that is not in the Trends charts. With the Find SQL feature, you can search for any SQL statement based on what you know about it. You can specify the time range when it was likely to run, and then apply any combination of filters and search strings:
-
Even if you don't know anything about the SQL text, you can apply filters to locate SQL statements that were executed by a certain user, ran as part of a certain application, were executed from a certain computer, or queried a specific database.
-
If you know anything about the SQL text, you can enter search strings such as table names or the operation being performed. In simple search mode, you can enter search terms or place double quotes around phrases. Switch to advanced mode to include wildcards, grouping, Boolean operators, and other advanced features.
When you locate the SQL statement, click the SQL hash or name to display detailed information about it on the Query Details page. For detailed information about using the Find SQL feature, see this topic.
The Find SQL feature is enabled by default for new installations. If you upgraded from an earlier version, the feature is not enabled by default. You can enable or disable this feature globally or for specific database instances. For more information, see this topic.
Tracking SQL Server database backups
When database backups fail or are not performed regularly, organizations run the risk of losing crucial data. DPA 2021.1 includes new metrics and alerts to make you aware of any issues and ensure that backups are performed on schedule.
New metrics
DPA 2021.1 includes the following new metrics. You can alert on any of these metrics.
For more information about these metrics, see SQL Server metrics collected by DPA. For information about alerting on these metrics, see Configure a DPA Resources alert.
Metric | Description |
---|---|
Active Backup Jobs | The number of currently running backup jobs for the instance. If this number is higher than expected, it can have performance implications or indicate issues with the scheduled backups. |
Sum of All Backup Assets Required for Recovery of All DBs (GB) | The cumulative size, in GB, of all the backup assets for all databases in the SQL Server instance that are required to recover to the current point in time. |
Longest Time for a DB without a Successful Full Backup (days) |
The longest time that any database in a SQL Server has gone without a successful full backup. If a SQL Server includes databases that do not require regular backups, you can exclude databases from this metric and the metrics below. |
Longest Time for a DB without a Successful DB Backup (Diff or Full) (days) |
The longest time that any database in a SQL Server has gone without a successful full or differential backup. |
Longest Time for a DB without a Successful Transaction Log Backup (hours) |
The longest time that any database in a SQL Server has gone without a successful transaction log backup. |
New alerts
DPA 2021.1 includes the following new Administrative alerts.
Alert | Description |
---|---|
SQL Server Backup Frequency |
Alerts you if the number of days since the last backup of the specified type (full, differential, or transaction log) exceeds the threshold. |
SQL Server Recovery Backup Assets Size |
Alerts you if the size of all backup assets required to recover a database exceeds the threshold, specified in MB. |
SQL Server Backup Jobs Running | Alerts you if the number of currently running backup jobs for a specified database instance exceeds the threshold. |
SQL Server Backup Time Allotted | Alerts you if the time required to complete the last backup of the specified type (full, differential, or transaction log) exceeds the threshold. |
New advanced option
By default, DPA tracks backups for all databases that have previously been backed up. However, a SQL Server instance might contain databases that have been backed up but do not require frequent backups (for example, databases used for testing).
Use the advanced option TRACK_BACKUPS_FOR_DBS
to specify the databases in a SQL Server instance whose backups DPA should track. This option specifies which databases DPA uses to calculate the "Longest Time" backup metric values. It can (optionally) be used to specify which databases DPA uses to calculate the values that trigger the following backup alerts:
- SQL Server Backup Frequency
- SQL Server Recovery Backup Assets Size
- SQL Server Backup Time Allotted
For more information, see Exclude SQL Server databases from backup metrics and backup alerts.
Tracking information about the SQL Server TempDB database
Space required by the TempDB database fluctuates based on the number of queries running and the nature of those queries. If TempDB fills up and cannot autogrow, the performance of all queries is affected.
DPA 2021.1 includes the following TempDB metrics to help you monitor the amount of space needed and to determine what types of objects require the most space. These metrics are shown on the TempDB tab.
For more information about these metrics, see SQL Server metrics collected by DPA.
Metric | Description |
---|---|
Total TempDB Log File Size |
The amount of disk space allocated for the log file in the TempDB database over time. |
TempDB Log File Utilized Space | The amount of space allocated to the TempDB log file that is currently being used. |
TempDB Log File Free Space |
The amount of space allocated to the TempDB log file that is currently free. |
TempDB Log File % Free Space |
The percentage of space allocated to the TempDB log file that is not currently being used. |
TempDB Free Space |
The amount of free space in TempDB. Spaced used in TempDB fluctuates based on the nature and volume of the SQL statements that are currently running. |
TempDB Internal Objects |
The amount of space in TempDB used by internal objects. |
TempDB User Objects |
The amount of space in TempDB used by user objects. User objects are temporary objects explicitly created by users. They include temporary tables and indexes, temporary stored procedures, table variables, and cursors. |
TempDB Version Store |
The amount of space in TempDB used by the version store. |
TempDB Mixed Extents | The amount of space in TempDB used by mixed extents. Mixed extents are shared by up to eight objects. |
Information about PostgreSQL wait types
DPA 2021.1 includes detailed descriptions of common PostgreSQL wait types and suggested resolutions. On the Query Details page, click the information icon next to the wait name to display this information. On the Top SQL Statements chart, click the name of the wait type.
Updated UI for resource metric charts on the Resources tab
Charts on the Resources tab are clearer and easier to read. The final value in the selected time period is displayed in a blue box to the right of the chart. When you move the cursor over the chart, the box displays the value for the currently selected time. Periods during which the value violated the warning or critical threshold are shaded in yellow or orange.
The time picker and Resource settings dialog box (where you can set or change thresholds) have also been updated. For more information, see View resource metrics in DPA and View or change DPA resource metric thresholds.
Baselines for metrics are no longer shown.
Updated UI for charts on the DPA home page
Charts on the DPA home page have also been updated. Hover over any bar or any area of the line chart to display the values for each monitored instance at that time.
New security role for user management
Accounts with the User Manager role have privileges to create and manage DPA user accounts, but they cannot view data collected by DPA or perform any other DPA tasks.
By default, accounts with the Administrator role also have privileges to create and manage DPA user accounts. To enforce a strict separation of duties, you can remove user account management privileges from the Administrator role.
Changes to system requirements
The following changes affect the DPA 2021.1 system requirements and the database instances DPA can monitor:
- A MySQL 8 database can be deployed as the DPA repository database.
- DPA can monitor Db2 11.5 and PostgreSQL 13.x instances.
- Microsoft Internet Explorer (IE) and legacy versions of Microsoft Edge are no longer supported browsers. (See End of support.)
- CPU, RAM, and disk space requirements for the DPA server have changed.
- If the Find SQL feature is enabled, a new requirement has been added for the disk space needed to store the Find SQL indexes.
New customer installation
For information about installing DPA 2021.1, see the DPA Installation and Upgrade Guide. You can download a free trial from the SolarWinds website.
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 2021.1
DPA 2021.1 fixes the following issues.
Case Number | Description |
---|---|
00604563 |
If you create a SQL Server Availability Group Status Change alert and select "Notify when level changes" as the notification policy, DPA sends a notification whenever the level has changed including when it returns to Normal. |
N/A |
When you are monitoring an Azure SQL Managed Instance (ASMI) that is registered via the public endpoint, DPA no longer displays |
00585608 | In previous versions, DPA sometimes failed to detect that pg_stat_statements was enabled on a monitored PostgreSQL instance, and therefore did not display statistics for that instance. This issue is resolved. |
00570938 |
Table tuning advisors display information about table fragmentation. In some environments, the query to get table fragmentation information can take a long time and will sometimes time out. DPA 2021.1 provides the advanced option
|
00574053 |
Monitoring a PostgreSQL database instance (not an EDB Postgres instance) no longer results in the following error being logged to the PostgreSQL server:
If the error is reported on an EDB Postgres instance, the check is performed less frequently to avoid filling up the logs. |
00594706 |
A second stats poll query has been added to collect data from SQL Server monitored instances. This query avoids overcounting certain types of SQL statements. By default, DPA 2021.1 uses the same SQL Server stats poll query as DPA 2020.2. If you are experiencing an issue with DPA overcounting SQL statements on SQL Server instances, you can configure DPA to use the new stats poll query by setting the advanced option |
00446644, 00558602, 00571154, 00620837 |
To improve security, DPA has updated a number of third-party components and libraries shipped with the product. In addition, DPA removed a dependency on Hibernate Validator and made other changes related to third-party software. |
00495927 | To improve security, the HTTP methods OPTIONS and TRACE are disabled in the version of Apache Tomcat shipped with DPA. |
Known issues
Database types supported for the DPA repository |
---|
Issue: In the Repository Creation Wizard, the line that lists variations of MySQL that are supported for the DPA repository includes MariaDB. However, MariaDB is not supported for the DPA repository. For DPA 2021.1.x, the list of MySQL variations should include only MySQL, Amazon RDS for MySQL, or Amazon Aurora for MySQL. |
Resolution/Work-around: For a complete list of the database types and versions supported for the DPA repository, see the System Requirements for your version of DPA. |
The DPA Options page does not open |
---|
Issue: If the file containing the DPA SQL authentication password is misconfigured, the DPA Options page does not open. This file can become misconfigured when password protection for DPA features that allow custom SQL is configured, and a password containing '<' or '>' characters was not enclosed with CDATA when it was entered. |
Resolution/Work-around:
|
DPA cannot monitor a PostgreSQL database instance with multiple connection properties |
---|
Issue: If you enter multiple connection properties in the JDBC URL field (either in the Registration Wizard or the Update DB Instance Connection Wizard) for a PostgreSQL database instance, DPA cannot monitor the instance. DPA repeatedly attempts to start monitoring the instance, but monitoring fails to start. |
Resolution/Work-around: Change the property separator in the |
Creating the repository user when creating a MySQL 8.0 repository database |
---|
Issue: For MySQL 8.0, the default authentication plug-in has changed from |
Resolution/Work-around:
|
Alerts stop working after a database instance display name is changed |
---|
Issue: If you include a database instance in an alert and then change the display name of the database instance, the alert stops working for that instance and emails are not sent. Even though the instance name appears to be updated in the alert definition, it is not updated on the Alert Status tab. |
Resolution/Work-around: Open the alert definition and save it again, without making any changes. Saving the alert definition updates the name on the Alert Status tab. |
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. |
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. |
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 or Workaround: Disregard the values that are incorrect on your version of SQL Server. You can also disable the collection of a metric that shows incorrect data. |
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. |
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 |
Resolution/Work-around:
|
Deprecation notices
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.
Type | Details |
---|---|
Database-specific mass registration spreadsheets | Mass registration spreadsheets specific type of database, such as Oracle or SQL Server, are still included in DPA 2021.1, but they will be removed in an upcoming release. When they are removed, mass registrations for any type of database will use the spreadsheet for all database types. |
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 2021.1 release, but support will be removed in an upcoming release. |
End of life
Version | EoL Announcement | EoE Effective Date | EoL Effective Date |
---|---|---|---|
DPA 12.0 |
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. |
DPA 11.1 |
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.
End of support
This version of Database Performance Analyzer no longer supports the following platforms and features.
Type | Details |
---|---|
Supported browsers |
Internet Explorer (IE) and legacy versions of Microsoft Edge are not supported browsers. If you access DPA using these browsers, some DPA functionality is not available or does not function correctly. For example:
Chromium-based versions of Microsoft Edge are still supported. See the DPA 2021.1 System Requirements for a complete list of supported browsers. |
Legal notices
© 2021 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.