To kick off the Q4 releases, I am happy to announce Generally Availability of Database Performance Analyzer 11.1.   This release continues to build momentum on previous releases by extending our support of Availability Groups, supporting the latest databases, and improving the DPA interface.  We've also added a subscription option when you deploy DPA in the Amazon cloud.

 

Support for New Database Versions

We'd like to announce official support for the following databases:

  • SQL Server 2017 on Windows
  • SQL Server 2017 on Linux
  • Oracle 12.2
  • MariaDB 10.0, 10.1 and 10.2
  • IBM DB2 11.1

When integrated with Orion, these databases will appear in DPAIM.

 

Availability Groups:  Status, Alerts and Annotations!

New in version 11.1, DPA regularly polls the status of all SQL Server Availability Groups (AGs) contained in the monitored instance. The DPA Home page displays a new status icon which tells you that AGs are present in a monitored instance.

 

DPA’s new AG monitoring gives you the ability to:

  • See the status of all your AGs on the home page, including a new filter widget.
  • When you drill down, see the status of AGs, databases, and replicas. This includes synchronization and failover status information.
  • See annotations on trend charts that show when AG failovers have occurred. The annotations show you the previous and current replica (from/to), and allows you to correlate failovers to changes in load.
  • Send an alert email when:
    • An AG failover occurs.
    • An AG status becomes Partially Healthy and Not Healthy.

For a detail view of new AG features, see this feature post:  DPA 11.1: Improved monitoring of SQL Server Availability Groups

HomePageAGInfo.png

AG_summary.png

 

Amazon Subscription

Have a lot of databases in the Amazon cloud?  You can now monitor them via your Amazon subscription, simply start up DPA from the AWS Marketplace, connect up a repository and start monitoring your databases. All currently supported databases can be monitored, and you can integrate DPA with your Orion server and see the data in Orion.

 

Improved Wait Time Status Indicator

The wait time indicator on the home page has been improved in two ways.

  • There are 3 status (Green, Yellow, Red) instead of 2 (Blue, Red).  Default thresholds are now 1.3x and 1.6x the historical wait time for Yellow and Red, respectively.
  • We evaluate every 10 minutes, instead of once an hour.

This increased frequency and new thresholds allow DPA to show you wait time pressure much quicker than previous versions.

This new status is propagated to Orion via the integration module.

 

And a whole lot more!

  • 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
    SQLSearchResults.png
  • Improved instance filter includes if instance monitor is on/off.
    status indicator.png
  • New icons and images that align better with Orion
  • See the DPA 11.1 Release Notes for the rest!

 

What's Next?

Don't see what you are looking for here? Check out the What We Are Working On for DPA (Updated Nov 6, 2017) post for what our dedicated team of database nerds and code jockeys are already looking at.  If you don't see everything you've been wishing for there, add it to the Database Performance Analyzer Feature Requests.