Documentation forDatabase Performance Analyzer

DPA 2024.3 release notes

Release date: July 31, 2024

Here's what's new in Database Performance Analyzer 2024.3.

Learn more

DPA integrates with the SolarWinds Platform. For information about bug fixes and improvements to the integration module, see the SolarWinds Platform release notes.

New features and improvements in DPA

Last updated:

Send DPA alert notifications to PagerDuty or ServiceNow

You can use Platform Connect to connect DPA with SolarWinds Observability. When the connection is established, DPA alert notifications can be sent to third-party notification services that are configured in SolarWinds Observability. Currently, DPA supports sending alert notifications to PagerDuty and ServiceNow.

DPA users with subscription licenses are eligible to connect to SolarWinds Observability. Users doing a 14-day evaluation and users with temporary licenses (for a fixed term) are also eligible.

Platform Connect beta users

If you used the beta version of Platform Connect to connect DPA and SolarWinds Observability, the formatting of alert notifications from DPA has been improved in this release to make them easier to read, and additional information is included. The description includes the alert name, the database name, and the severity. Custom details include information about the alarm level, the alert description, and more.

Before upgrading from the Platform Connect beta version to the version provided with DPA 2024.3, complete the steps under Before you upgrade!

DPA can use the CyberArk LogonDomain value

In previous versions, if DPA was configured to use credentials stored in CyberArk, DPA ignored any value in the LogonDomain field of the CyberArk object. If a domain needed to be specified during authentication, it was specified in the UserName field, with the format DOMAIN_NAME\Username.

In DPA 2024.3 and later, a domain can be specified in either the LogonDomain field or the UserName field of the CyberArk object:

  • If the LogonDomain field contains a value and the UserName field does not contain a backslash (\), DPA prepends the domain name and a backslash to the user name.

    For example, if CyberArk sends the following object, DPA prepends the LogonDomain value to the UserName value, and the value used for authentication is MYDOMAIN\MyUserName.

    {
        "Content": "ABCD123",
        "Folder": "Root",
        "LogonDomain": "MYDOMAIN",
        "Name": "testobject3",
        "UserName": "MyUserName",
        "Safe": "Test",
        "PasswordChangeInProcess": "False"
    }
  • If the UserName field contains a backslash (\), DPA uses that value and ignores the LogonDomain field (if present).

    For example, if CyberArk sends the following object, DPA uses the value MYDOMAIN\MyUserName for authentication.

    {
        "Content": "ABCD123",
        "Folder": "Root",
        "Name": "testobject3",
        "UserName": "MYDOMAIN\MyUserName",
        "Safe": "Test",
        "PasswordChangeInProcess": "False"
    }

Additions to monitored instances and system requirements

DPA 2024.3 adds support for monitoring the following:

  • The DPA repository database can be created on:

    • Oracle 23c
    • MySQL 8.3
  • DPA can monitor the following database instances:

    • Oracle 23c
    • MySQL 8.3
    • PostgreSQL 16
    • EDB Postgres 16

Fixes

Case number Description
01503236, 01527114, 01634906

If the name of a monitored database instance contains a dot (for example, orders.test), table, index, and query advisors no longer fail with the message There was an internal server error. Contact your DPA administrator or try later.

01609821

Upgrading a DPA deployment with an Oracle repository no longer fails with the error ORA-00910: specified length too long for its datatype.

01564015

Attempting to display information about active sessions on the Real Time Sessions view for a Sybase 16 database instance no longer fails with the exception Ambiguous column name status.

01568103

When you change the default refresh rate for DPA Central, data is refreshed at the specified interval. Additionally, when the data is refreshed, the currently viewed tab does not change.

01611335

When the Tablespace Freespace alert runs against an Oracle database instance, it is no longer broken.

01620741, 01686231

When the Database Freespace alert runs against a SQL Server or Azure SQL database instance, it no longer fails with an error such as java.lang.illegalStateException: No DataSource set.

01598607, 01626937

When the DPA monitoring database instance is stopped, all connections to Db2 database instances are now cleared automatically.

Before you upgrade!

Last updated:

If you used the beta version (2024.2) of Platform Connect to connect DPA and SolarWinds Observability, complete the following steps before you upgrade to DPA 2024.3 or later:

  1. Open the following file in a text editor:

    DPA-install-dir\iwc\tomcat\ignite_config\idc\system.properties

  2. Add the following lines:

    #environment of platform connect feature
    com.confio.platformconnect.env=@pc.env@
  3. Save the file.

Installation or upgrade

Last updated:

For new installations, you can download the installer from the SolarWinds website or from the Customer Portal. For more information, see the DPA Installation and Upgrade Guide.

For upgrades, 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.

Known issues

Last updated:

Custom alerts and custom metrics are not supported on a Db2 server with multiple databases

When you are monitoring a Db2 server with multiple databases, custom alerts and custom metrics do not return data for all databases. Because of a limitation with MON_GET_* functions, custom alerts and custom metrics are supported only for connected databases.

Resolution or Workaround: None.

Mass registration for Azure SQL Database instances

The script to generate the mass registration file for an Azure SQL Database instance has not yet been updated to reflect the changes to mass registration fields. DPA 2024.2 and later cannot use the file created by this script.

Resolution or workaround: Use the wizard or the API to register Azure SQL Database instances.

DPA does not always use the Microsoft JDBC driver by default

When you register a database instance for monitoring, DPA should use the Microsoft JDBC driver by default. However, it uses the jTDS JDBC driver by default if the system.properties file does not contain the following entry:

com.confio.ignite.jdbc.sqlserver.useJtdsDriver=false

This missing configuration is likely to happen on DPA servers where older versions of DPA were initially installed, before DPA began using the Microsoft Driver.

Resolution or Workaround: Open the system.properties file in a text editor, and determine if it contains the entry above. If not, manually add it and save the file.

PostgreSQL OS CPU utilization not showing data on a Windows installation

When PostgreSQL is installed on a server with a Windows operating system, the O/S CPU Utilization resource metric in DPA does not display any data. It displays the message Chart doesn't have data collected for selected time period.

If PostgreSQL OS CPU utilization data is missing in other environments, make sure the system_stats extension is installed. For instructions, see Register a PostgreSQL database instance and prepare for monitoring.

Resolution or Workaround: None.

Importing an alert definition without the associated database assignment rule

In some situations, the log file shows the status of an imported alert definition as both Imported and Failed. This occurs when the alert definition uses a database assignment rule, but the rule was not imported and did not already exist on the server.

The two statuses indicate that the alert definition was imported, but the attempt to associate the database assignment rule failed.

Resolution or Workaround: When you import an alert definition that uses a database assignment rule, either import the rule or ensure that it already exists on the server.

If you imported an alert definition and the associated rule is missing, you must edit the alert definition to specify the database instances. (You can specify instances by manually selecting them or by applying a rule.)

End of life

Last updated:

Version EoL announcement EoE effective date EoL effective date
DPA 2023.2 July 18 2024 End-of-Life (EoL) announcement - Customers on DPA version 2023.2 or earlier should begin transitioning to the latest version of DPA. October 18, 2024 End-of-Engineering (EoE) - Service releases, bug fixes, workarounds, and service packs for DPA version 2023.2 or earlier will no longer actively be supported by SolarWinds. October 20 2025 End-of-Life (EoL) - SolarWinds will no longer provide technical support for DPA version 2023.2 or earlier.
DPA 2023.1

April 19, 2024 End-of-Life (EoL) announcement - Customers on DPA version 2023.1 or earlier should begin transitioning to the latest version of DPA.

May 20, 2024 End-of-Engineering (EoE) - Service releases, bug fixes, workarounds, and service packs for DPA version 2023.1 or earlier will no longer actively be supported by SolarWinds. May 19, 2025 End-of-Life (EoL) - SolarWinds will no longer provide technical support for DPA version 2023.1 or earlier.
DPA 2022.4

January 19, 2024 End-of-Life (EoL) announcement - Customers on DPA version 2022.4 or earlier should begin transitioning to the latest version of DPA.

May 20, 2024 End-of-Engineering (EoE) - Service releases, bug fixes, workarounds, and service packs for DPA version 2022.3 or earlier will no longer actively be supported by SolarWinds. May 19, 2025 End-of-Life (EoL) - SolarWinds will no longer provide technical support for DPA version 2022.3 or earlier.
DPA 2022.3

November 23, 2023 End-of-Life (EoL) announcement - Customers on DPA version 2022.3 or earlier should begin transitioning to the latest version of DPA.

April 12, 2024 End-of-Engineering (EoE) - Service releases, bug fixes, workarounds, and service packs for DPA version 2022.3 or earlier will no longer actively be supported by SolarWinds. April 14, 2025 End-of-Life (EoL) - SolarWinds will no longer provide technical support for DPA version 2022.3 or earlier.

See the End of Life Policy for information about SolarWinds product life cycle phases. To see EoL dates for earlier DPA versions, see DPA release history.

Legal notices

© 2024 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.