Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.1 Release Notes

DPA 11.1 Release Notes

 

 

Last updated: December 6, 2017

These release notes describe the new features, improvements, and fixed issues in DPA 11.1. They also provide information about upgrades and describe workarounds for known issues.

For information about DPAIM 11.1, see the DPAIM 11.1 release notes.

New features and improvements

Improved Monitoring of Availability Groups

When a SQL Server database instance includes Availability Groups (AGs), the DPA homepage provides the following information:

  • The AG status icon AG_status_icons.png identifies database instances that include AGs. The color of the dot indicates the AG status. 
  • An AG status summary box shows the number of database instances with partially healthy or unhealthy AGs. As with other status summary boxes, click the filter next to a status to display only those instances.
    AG_filter.png

When you drill in to a database instance that includes AGs, click the AG Status tab to see the status of AGs, databases, and replicas, including synchronization and failover status information.

Annotation when an AG failover occurs

Annotations are automatically added to wait time charts when an AG failover occurs. The annotations allow you to compare changes in performance before and after a failover.

AG alerts

You can configure DPA to alert you when:

  • An AG status becomes Partially Healthy and Not Healthy
  • An AG failover occurs

>> Learn more about improved monitoring for AGs

Subscription licensing for AWS DPA servers

If you have databases in the Amazon cloud, you now have the choice to monitor them with subscription pricing. Simply deploy the DPA 11.1 server from the Amazon Web Services (AWS) Marketplace. As you register databases and monitor them, DPA charges your Amazon Subscription through the AWS Metering Service. DPA charges you based on the number of database instances you monitor each hour. See the AWS Marketplace for details and pricing.

If you want to use your individual DPA licenses in the Amazon cloud, simply deploy a regular EC2 instance, install DPA, and apply your license. You cannot mix using individual DPA licenses and subscription licensing on a single instance of DPA.

For more information about deploying DPA in AWS, see Launch SolarWinds DPA on Amazon AWS in a Linux AMI.

Improved wait time status meter

The following improvements have been made to the wait time status meter on the DPA homepage:

  • DPA evaluates status every 10 minutes instead of once an hour.
  • There are now three statuses instead of two. 

DPA uses the same statuses as the Orion Platform: green (normal), yellow (tracking high), and red (tracking very high). When you integrate DPA with the Orion Platform, status information is displayed consistently. 

DPA data in Performance Analysis (PerfStack™) dashboards

With version 11.1 of the DPA Integration Module (DPAIM), users can add DPA data to PerfStack dashboards, including wait time, database metrics, VM metrics, and custom metrics. When you identify a time period with significant wait times, you can use the Data Explorer to examine the SQL statements that were executed during that period. Both DBAs and non-DBAs can use this data to identify relationships between database wait times and other factors in the environment.

DPA users who do not own other SolarWinds products can access DPA data in PerfStack. You can install DPAIM 11.1 stand-alone (no other Orion products required), and use all of the Orion features available to DPA data.

>> Learn more about DPA data in PerfStack

>> Learn more about PerfStack

UI improvements

  • The database instance dropdown menu displays a status indicator.

    status indicator.png

  • When you search for a SQL statement while creating an alert or a report, the search results include each SQL statement's total wait time for the last 7 days. By default, the results are ordered by wait time.

    SQLSearchResults.png

    To configure the amount of wait time, change the value of the advanced option REPORT_SEARCH_WAIT_TIME_DAYS.

  • Icons have been updated.

Changes to system requirements

DPA 11.1 adds support for the following versions:

Monitored databases
  • Oracle 12.2
  • IBM DB2 11.1
  • MariaDB 10.0, 10.1, and 10.2
  • SQL Server 2017 (Windows and Linux)
Repository database
  • Oracle 12.2
  • SQL Server 2017
Virtual environment
  • vCenter Server 6.5
  • ESX/ESXi 6.5

DPA 11.1 removes support for the following versions:

Monitored databases IBM DB2 9.5
Virtual environment
  • vCenter Server 5.1
  • ESX/ESXi 5.1

For a complete list of DPA 11.1 system requirements, click here

New customer installation

For information about installing DPA, see the DPA 11.1 Installation Guide.

Before you upgrade!

If you are upgrading from a previous version, be aware of the following considerations:

  • Back up your current DPA deployment and repository database.

  • DPA 11.1 requires JRE 1.8. If you configured DPA to use an external JRE, DPA verifies it is version 1.8 or later. If the verification fails, DPA attempts to use the JRE included with the installation.

  • If your repository database is MySQL and you are upgrading from DPA 10.2 or earlier, DPA drops the CON_ALERT_HISTORY and CON_ALERT_HISTORY_RESULT tables during the upgrade due to column resizing. Follow the instructions in this article to back up your repository before upgrading, and restore your alert history after upgrading.

How to upgrade

If you are upgrading from a previous version, use the following resources to plan and implement your upgrade:

  • Use the DPA Upgrade Guide to help you plan and execute your upgrade.
  • When you are ready, download the upgrade package from the SolarWinds Customer Portal.
  • Upgrade your production server. If you are upgrading from DPA 9.0 or earlier, retrieve your license activation keys from the Customer Portal to complete the upgrade.

Fixed issues

DPA 11.1 fixes the following issues.

Case number Description

929798, 1082802, 1094705, 1166631, 1198885, 1213479, 1216265

Multiple security fixes have been applied. 

1091237, 1185657

To improve the efficiency of the statistics query on Oracle instances, the default value for the ORACLE_STATS_POLL_V2 advanced option has been changed to TRUE.

1188376

The query for the Distinct Machine Total metric has been updated to run on case-insensitive database instances, such as Sybase ASE 15.7 and later. 

1195305

When a non-admin user creates an alert, the Create Alert page no longer displays the Add Contact and Add Contact Group buttons, which are features reserved for admin users.

1178685

Setting the QUICK_POLL_INTERVAL to more than 1 poll per second no longer causes errors in database summarization. 

1171023

SQL Server database instances with Chinese collation can be registered for monitoring.

1167606

Additional LDAP properties have been added to the system.properties file. You can use these properties to override the default AD/LDAP connection settings, such as the connection timeout value. For more information about the new properties, see Resolving AD/LDAP connection errors in DPA.

1197021

When a SQL Server database instance that contains Availability Groups (AGs) is registered and the license is not automatically allocated, DPA now correctly recognizes the instance as having AGs.

1138028

DPA now displays the correct time when the DPA server is located in a Turkish time zone.

1137186

Newly created repositories will use the UTF-8 character set, which supports multi-byte characters (such as Chinese).

1135377

An Active Directory group with a plus sign (+) in the name can be added to DPA. Escaping the plus sign is no longer necessary.

N/A

If you choose the wrong template during mass registration, DPA displays an error message that accurately describes the problem.

N/A When you are updating connection details for a SQL Server database instance, the Update Connection Info wizard no longer requires port information when the database instance is registered with the instance name.

1073989, 1103885, 1107496

Root blockers summarization no longer consumes large amounts of memory when DPA is monitoring a database instance that has very high amounts of blocking.

1139149

If a database requires SSL and the network uses NTLMv2, you no longer need to enter a value in the Advanced Connection Properties section to register the database. 

1281717

When you are monitoring an Oracle 11.x or higher database instance, the plan poll query in DPA no longer fails with the error "Character string buffer too small."

Known issues

Registering with a virtual IP address that routes to an AG listener

Issue: If you have a SQL Server that contains one or more AGs and you register it with a virtual IP address that routes to an AG listener, DPA does not detect that you have registered an AG via the listener. Because the registered IP address does not match an AG listener's IP address, DPA behaves as if it were monitoring an instance and does not expect that monitoring will fail over when a listener failover occurs.

As a result:

  • When the listener that you intended to register fails over, DPA does not detect that failover and might falsely detect other AG failovers. (To avoid this, see the Recommendations below.)
  • DPA does not automatically name the database instance in the format <PrimaryReplicaName> via <ListenerName>.
  • The listener name is not displayed where it normally would be, such as in the Availability Group Summary view.
  • The advanced option AG_STATUS_ROLLUP_USE_PRIMARY, which specifies how the AG status is calculated when an AG is registered via the listener, is not available. 

All other AG monitoring functionality is available. DPA will follow the listener after a failover, and continue monitoring the primary replica.

Recommendations: SolarWinds recommends registering the AG with the IP address of the listener instead of the virtual IP. However, if you choose to register with the virtual IP address:

  • Do not set the SQL Server Availability Group Failover alert for this monitored instance.
  • Disable failover annotations for this monitored instance. To do so, change the value of the advanced system option AG_EVENT_ANNOTATIONS_ENABLED. 

Incorrect metric values reported for SQL Server 2017 on Linux

Issue: When you are monitoring a SQL Server 2017 database instance that runs on a Linux server:

  • The O/S CPU Utilization resource and the Instance CPU Utilization resource always show usage at 100%. 
  • The O/S Memory Utilization resource always shows usage at 0%.

SQL Server reports these values.

Work-around: Disregard these metric values.

Limitations when monitoring AGs deployed on SQL Server 2017 on Linux

Issue: When you are monitoring a SQL Server 2017 AG that runs on Linux, some information or functionality might be unavailable:

  • If you register the AG via the listener, the listener name is not included in the instance name. 
  • "Unknown" is displayed for the Failover Mode and the Cluster Name. 

Work-around: None.

Time zone selection

Issue: When you are registering a database instance that runs in the cloud, the time zone selected by default is the first one matching an offset of your browser session. This might be incorrect under some circumstances. Also, the drop-down menu for selecting the time zone contains a long list of selections that are loaded from the Java Virtual Machine.

Work-around: Manually select the correct time zone for your environment.

Attempting to run a report returns the error DPA Unable to generate the chart

Issue: When the DPA server is running RHEL 7.4 (or its distributions, such as Oracle Linux 7.4), DPA returns the following error when you try to run a report: 

DPA Unable to generate the chart: java.lang.ArrayIndexOutOfBoundsException: 0

Work-around: Follow the instructions in this article to change the default font used by RHEL 7.4.

DPA has high CPU utilization for long periods when Embedded Mail Server is used

Issue: When Embedded Mail Server is selected as the mail server configuration option and an attempt to send email fails (for example, because of an environmental issue such as a firewall or the mail server configuration), DPA saves the email into a queue and tries to send the email again. If the problem persists, having a large number of emails in the queue causes high CPU utilization.

Work-around: Change the mail server configuration, or fix the issue that is preventing mail from being sent. See this article for more information. 

DB2 10.5 reporting wait time as type "NONE"

Issue: If you are monitoring a DB2 10.5 database instance, you might see wait times with the type "NONE."

Work-around: Exclude this wait type from monitoring. To do this, open Advanced Options, click DB Instance Options, and select a database instance. Then click Wait Events in the upper-left corner.

CPU utilization for a large number of CPU cores

Issue: The CPU utilization metric does not display the correct data for multi-core or -socket environments. DPA uses a deprecated view that does not provide consistent data for environments using a high number of cores or sockets.

Work-around: Follow the instructions in this KB article.

Incorrect execution counts for SQL statements

Issue: When SQL Server purges statistics from the previous cached query plan for a SQL Statement from the master.sys.dm_exec_query_stats table, the execution count that DPA shows can be incorrect. This count can be extremely high, and doesn't match the execution count retrieved by querying the DPA repository. 

Work-around: Disregard the incorrect execution counts.

Registering an Oracle database instance that uses only SHA-2 to calculate checksums

Issue: If an Oracle database instance is configured to use only SHA-2 (Secure Hash Algorithm 2) to calculate checksums, the following error message is displayed when you try to register it as a monitored instance or as the DPA repository:

An unknown error has occurred. The provided message is "Could not get JDBC Connection; nested exception is java.sql.SQLException: Oracle Error ORA-12650".

Work-around: To enable DPA to connect to Oracle databases that use only SHA-2, you must update the JDBC driver as described in this KB article.

SQL error on Blocking tab 

Issue: The Blocking tab becomes unresponsive if there are more than 32,767 records on the Real Time Session page.

Work-around: None.

Repository growth when monitoring a VM with many disks

Issue: When DPA is monitoring a database instance on a VM with a large number of disks, the CONV_METRIC_DETAIL tables grow rapidly, resulting in a large repository.

Work-around: Do one of the following:

  • Lower the sampling interval.
  • Disable the VM Disk Device metrics. (For instructions, see this KB article.)
  • Lower the value of the VSPHERE_METRICS_CLEAN_DAYS options to reduce the amount of data being stored. (For instructions, see this KB article.)

The ApplicationIntent flag is ignored when you are registering an AG listener

Issue: If you are registering a secondary replica in an AG cluster and you specify the ApplicationIntent=ReadOnly flag, this flag is ignored and DPA connects to the primary replica. 

Work-around: Follow the instructions under "Enhancements" in this KB article

Unable to name a SQL statement from the Blockers tab

Issue: On the Blockers tab in the "SQL Statements Executed by Blocking Session" chart, you can click a SQL statement to open the SQL Properties dialog. The dialog includes the Name and Description fields, but they are read-only.

Work-around: Name the SQL statement from a different location in DPA.

Deprecation notices

  • DPA will be ending support for VMware vCenter Server 5.5 and VMware ESX/ESXi Host 5.5 in an upcoming release. DPA 11.1 still supports VMware 5.5, but SolarWinds encourages users to upgrade to VMware 6.0 or 6.5 at their earliest convenience.

  • DPA 11.1 is the last version to support Windows Server 2008 R2 as a platform for the DPA server.

  • DPA 11.1 is the last version to support SQL Server 2008 R2 as a database repository for the DPA server.  DPA will continue to monitor SQL Server 2008 R2 database instances.

End of life

See End of Life Policy for information about end of life and end of engineering for SolarWinds products.

Version EoL Announcements EoE Effective Dates EoL Effective Dates
10.1 March 15, 2017 End-of-Life (EoL) announcement - Customers on DPA version 10.1 or earlier should begin transitioning to the latest version of DPA. June 15, 2017 End-of-Engineering (EoE) - Service releases, bug fixes, workarounds, and service packs for DPA version 10.1 or earlier will no longer actively be supported by SolarWinds. June 15, 2018 End-of-Life (EoL) - SolarWinds will no longer provide technical support for DPA version 10.1 or earlier.
10.0 March 15, 2017 End-of-Life (EoL) announcement - Customers on DPA version 10.0 or earlier should begin transitioning to the latest version of DPA. June 15, 2017 End-of-Engineering (EoE) - Service releases, bug fixes, workarounds, and service packs for DPA version 10.0 or earlier will no longer actively be supported by SolarWinds. June 15, 2018 End-of-Life (EoL) - SolarWinds will no longer provide technical support for DPA version 10.0 or earlier.

Legal notices

© 2017 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 and documentation are and shall remain the exclusive property of SolarWinds and its respective licensors.

SOLARWINDS DISCLAIMS ALL WARRANTIES, CONDITIONS OR OTHER TERMS, EXPRESS OR IMPLIED, STATUTORY OR OTHERWISE, ON SOFTWARE AND DOCUMENTATION FURNISHED HEREUNDER INCLUDING WITHOUT LIMITATION THE WARRANTIES OF DESIGN, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE, AND NONINFRINGEMENT. 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 and other SolarWinds marks, identified on the SolarWinds website, as updated from SolarWinds from time to time and incorporated herein, are registered with the U.S. Patent and Trademark Office and may be registered or pending registration in other countries. All other SolarWinds trademarks may be common law marks or registered or pending registration in the United States or in other countries. All other trademarks or registered trademarks contained and/or mentioned herein are used for identification purposes only and may be trademarks or registered trademarks of their respective companies.

 

 

Last modified

Tags

Classifications

Public