Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

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

DPA 12.1 Release Notes

 

doc-icon.png RC Documentation - The following content is draft content for Release Candidates. All content subject to change.

Last updated: January 16, 2019

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

DPA 12.1 new features and improvements

Anomaly detection

DPA makes it easy to find the big bars that represent long waits. But in some cases, a big bar is not a problem. The wait time is normal and expected. What you need to know is when something changes and wait times suddenly become much longer than normal. 

DPA 12.1 introduces an anomaly detection algorithm to identify unexpected increases in wait time. DPA collects historical data and uses it to "learn" what normal is. DPA's proprietary algorithm makes predictions based on this data. The predictions take into account the day of the week and the time of day. (For example, the expected wait time for 2 p.m. on a Wednesday might be different than the expected wait time for 2 a.m. on Saturday.) 

A new alert and an updated wait time meter (described below) let you know when wait times are significantly higher than expected. When you view information about the database instance that is experiencing unexpectedly high wait times, the Anomaly Detection chart below the Top SQL Statements chart shows you when anomalies occurred.

AnomalyDetectionChart.png

You can drill in to a day for a more detailed view. Click the name or hash value of a query that ran during an interval with high wait times to open the Query Details page, where you can view historical information about the query and get statistics for the selected time period.  

DPA also detects when wait times are lower than expected. For these time periods, the bar is below the baseline on the chart. Lower wait times are not assigned a Warning or Critical status, and DPA does not alert on them.

DPA REST API

DPA 12.1 includes a REST API, which can be used to automate management of the DPA server. You can use the API to securely connect to the DPA server and retrieve information or provision database resources. For example, you can make API calls to:

  • Register or unregister a database instance
  • Allocate or deallocate licenses
  • Start or stop monitoring
  • Add or remove annotations
  • Get information about licenses, monitored database instances, and annotations

Wait time meter changes

  • The color of the wait time meter is based on DPA's anomaly detection algorithm. When a wait time meter is yellow or red, it indicates that wait times for the associated database instance are significantly higher than expected for the current week day and time period.

    wait-time_meter.png

  • The wait time meter provides much more current status information for each database instance. The status is calculated every 10 minutes. The wait time meter indicates the amount of wait time during the six most recent 10-minute intervals (a rolling one-hour time period).

    In previous versions, the status was updated daily. Therefore, unusually long waits at 3 a.m. (for example) would cause the wait meter to stay yellow or red for the rest of the day, even though wait times were no longer high.

Alerting improvements

  • Values that are included in DPA alerts can now contain up to four decimal places. With this change, you can configure sub-second thresholds for DPA alerts.
  • A new alert, Database Instance Wait Time Anomaly, is available. This alert uses DPA's anomaly detection algorithm. It is triggered if the wait time of an instance was abnormally high during the most recently completed hour.

Redesigned Management Options page

The tabs have been removed from the Management Options page. The Monitor Setup, Administration, and Support options are all shown on one page for easier access.

Changes to system requirements 

DPA 12.1 adds support for the following versions:

Monitored database instances
  • Oracle 18.3.x
  • Microsoft SQL Server 2017 on Amazon RDS
Repository database
  • Oracle 18.3.x (on-premises only)
  • Microsoft SQL Server 2017 on Linux
DPA server OS
  • Windows Server 2019
Virtual environment
  • vCenter Server 6.7
  • ESX/ESXi 6.7

For a complete list of DPA 12.1 system requirements, click here.

Before you upgrade!

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

  • If you have specified that DPA use a Java installation other than the default version that DPA installs, you must update it to a supported version. (See End of Support for more information.)
  • In previous versions of DPA, SQL Server 2005 repository databases functioned (even though they were not supported). In DPA 12.1, SQL Server 2005 repository databases will no longer function. If you are still using a SQL Server 2005 database as the DPA repository, you must upgrade to a supported repository database version before you upgrade to DPA 12.1.

How to upgrade

 

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

Installation and upgrade information

For information about installing or upgrading DPA 12.1 see the DPA Installation and Upgrade Guide.

Fixed issues in DPA 12.1

DPA12.1 fixes the following issues.

Case number Description

00228844

When a SQL Server database is issuing queries with table variables, DPA no longer returns errors similar to Insert failed for CON_INDEX_ANALYSIS_350.

00218510, 00217926, 00190095, 00197874

Table Tuning Advisors no longer display internal server errors when a table includes more than 2,147,483,647 rows, or when a plan step uses over 4 billion rows in the query. 

00218903

DPA is able to monitor an Oracle database when PLANPOLL_ENABLED is set to False

00206303, 00200609, 00203379

Table Tuning Advisors no longer display internal server errors when the DPA repository is on a MariaDB database.

Using MariaDB as the DPA repository database is not supported. SolarWinds encourages users to move the DPA repository to a supported version of MySQL. For more information, see the DPA 12.1 System Requirements.

00198505

If the server name for the primary replica in a SQL Server availability group (AG) is reported as NULL, DPA is now able to retrieve the correct name and continue monitoring the AG. 

00176374

A special character has been removed from default-metrics-queries.xml. In some environments, this character prevented DPA from displaying CPU, page life, or read/write latency metrics.

00174373

Index analysis no longer fails with a null pointer exception error when a dot (.) is used in a table or database name.

00039067

Activating a license offline now works as expected.

1358875

Information is no longer missing from the Top Plans by SQL report.

00023478, 
1010458, 1325085

An issue with the DPA plan poll that caused DPA to return the following error and stop monitoring a database instance has been fixed:

Duplicate Key in object 'ignite.CONSPA_X'.

00243760, 
00247681, 
00200285
The performance of DPA's table tuning advisor feature has been improved. 

Deprecation notices

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
Repository database

Support for using SQL Server 2012 as the DPA repository database is deprecated. You can still use SQL Server 2012 as the repository database for DPA 12.1, but support will be removed in an upcoming release.

Monitored database instances Support for monitoring SQL Server 2008 database instances is deprecated. You can still monitor SQL Server 2008 database instances with DPA 12.1, but this functionality will be removed in an upcoming release.

End of support

DPA 12.1 does not run with JDK 8 or earlier versions. By default, DPA installs and uses OpenJDK 11, but you can also use Oracle JDK 11. 

If you have specified that DPA use a Java installation other than the default version that DPA installs, you must update it to a supported version. See either of the following articles for instructions:

Known issues

Attempting to launch DPA on a Linux server returns a Status 500 Internal Server Error

Issue: When DPA is installed on a Linux server, attempting to start it returns a Status 500 Internal Server Error. The 'Root Cause' section of the error message includes: 

Error creating bean with name 'displayOptionsController'

This occurs because the fonts that DPA requires are no longer available from the JDK.

Work-around: Install the required fonts. See this article for details.

DPA does not support MySQL 8.0

Issue: MySQL 8.0 is not supported for use as a DPA repository, and DPA cannot monitor MySQL 8.0 database instances.

Work-around: Use DPA with supported versions of MySQL.

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.

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.

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.

DPA repository creation on Azure SQL fails when the user name contains an @ symbol

Issue: When you attempt to create the DPA repository on an Azure SQL database, repository creation fails if you enter the user name in a format that contains an @ symbol (for example, dpa@myserver) on the Enter Repository Connection Information panel. For more information see this KB article.

Resolution: Enter the user name in a format without the @ symbol. For example, instead of dpa@myserver, enter only dpa.

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

 

Last modified

Tags

Classifications

Public