For those of you who didn’t know, Storage Resource Monitor 6.8 is currently available for download! This release continues our momentum of supporting new arrays that you all requested on THWACK® as well as deepening our already existing support for the most popular arrays.

 

Why don’t we go over some of what’s new in SRM with the 6.8 release?

 

NEW ARRAY SUPPORT - KAMINARIO®

We’re all really excited here about our newest supported array vendor: Kaminario®. With Kaminario® being an enterprise storage vendor that has a lot of exciting progress going on, we’re really excited to say that we now support their arrays, starting with K2 and K2.N devices. And we think that you will be to, if the voting in THWACK has anything to say about it.

 

Best of all, out of the box, this new support includes all the standard features you know and love: capacity utilization and forecasting, performance monitoring, end-to-end mapping in AppStack™, integrated performance troubleshooting in PerfStack™, and Hardware Health.

 

And, as always, we’re excited to share some screenshots.

 

Summary View

 

Hardware Health View

 

NEW HARDWARE HEALTH SUPPORT - DELL® COMPELLENT AND HPE 3PAR

Whether you’re a new customer to SRM or you’ve been a customer for a while, you know that there is a lot to be had when we extend support for an array to hardware health. With SRM 6.8, we focused on adding hardware health support to those arrays most popular with our customers. And so, we’re excited to announce hardware health support for Dell® Compellent and HPE 3PAR arrays. So now, starting in SRM 6.8, digging into these array types allows you to see details on fans, power supplies, batteries, and more.

 

A screenshot? Of course.

 

 

WHAT’S NEXT

Add in some bug fixes and smaller changes and you have SRM 6.8. We’re excited for you all to check it out.

 

If there are any other features that didn’t make it into SRM 6.8 but that you would like to see, make sure to add it to our Storage Manager (Storage Profiler) Feature Requests forum. But before you do, head over to the What We’re Working On page to see what the storage team already has in the works for upcoming releases.

 

And as always, comments welcome below.

 

- the SRM Team

I’m happy to announce the General Availability of Database Performance Analyzer (DPA) 12.1. This release focuses on deeper performance analysis and management of DPA through these cool new features:

  • Anomaly Detection Powered by Machine Learning
  • Management API
  • Upgraded Java
  • New Options Page
  • Alerting Improvements

Anomaly Detection Powered by Machine Learning

Users tend to log help desk tickets when things are running slower than normal, i.e., an anomaly. Those tickets often find their way to the database team’s inbox to check the database. DPA can be used to find issues when you have time to drill into the wait time data, but often, time is of the essence. Everyone wants answers immediately.

 

Tired of comparing the trends chart with previous days to decide what “normal” looks like? DPA 12.1 now does the work for you, using a machine learning algorithm to identify which hours are abnormal, and displays the information contextually on the trends page. Bonus! If DPA detects an anomaly in the last 60 minutes, it changes the wait time status on the home page, letting you quickly identify the database instances your users are waiting on.

 

The DPA wait meter on the home page is now powered by anomaly detection, and new correlation charts appear as you drill into an instance. For example, you may be reviewing the home page and suddenly see the wait meter turn red.

 

This is an indication the instance is having higher than normal wait times and may be having issues. Clicking on the wait meter takes you to a view of the last 24 hours, and the status of the last bar will match the wait meter.

 

Drilling into the last bar, we can start to unravel the root cause of the anomaly. In this example, we see heavy wait times on RESOURCE_SEMAPHORE_QUERY_COMPILE, usually an indication that one or more queries require more memory than is currently available. In our case, many queries were waiting on this wait type, indicating a potential memory shortfall on the database server, which is what we found to be the case. Without the anomaly detection feature, we may not have known about this problem.

 

For more about this story and others, see this feature post in the DPA Customer Success Center: DPA 12.1 feature: Anomaly detection - SolarWinds Worldwide, LLC. Help and Support .

Management API

DPA has many customers automating tasks within their database environments, and many of you have scripts that can deploy/destroy a database environment in minutes. The new REST API in DPA 12.1 can be used to further that automation to management of DPA itself as well as monitored instances. It can safely connect to DPA and issue calls to:

  • Add and remove instances
  • List, allocate, and deallocate licenses
  • Stop, start, and update passwords for monitors
  • Add, retrieve, and delete annotations
  • And more

 

DPA customers are already using the API to:

  • Create annotations when a new build of an application is installed
  • Add monitoring to a newly created database instance and allocate proper licenses
  • Stop and restart monitors before and after O/S patches

 

If you are using the DPA API to do cool things, reply to this post and let us know about it.

 

For more information about DPA’s Rest API, including an interface to try them out before building code around them, use the new Options page and the Management API Documentation link. Here’s a list of other useful pages when you are ready to put the API into action:

What Did You Find?

Our QA team uses DPA to help make sure our code performs well. The anomaly detection feature has helped them be more efficient when problems crop up. DPA pings them using anomaly detection alerts rather than a person being required to drill into every instance to find issues. They can then use the anomaly detection charts to quickly understand the issues. If you find interesting stories in your environment, let us know by leaving comments on this blog post.

 

We would love to hear feedback about the following:

  • Does anomaly detection improve your workflow for finding wait time issues?
  • Are there issues in your databases that DPA did not find, or flagged incorrectly?
  • Are you using the REST API? How much time does it save you? What processes are you automating?

What’s Next?

To learn more about the exciting DPA 12.1 new features, see the DPA Documentation library and visit your SolarWinds Customer Portal to get the new software.

 

If you don't see the features you've been wanting in this release, check out the What We Are Working On for DPA post for what our dedicated team of database nerds 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.

Filter Blog

By date: By tag:

SolarWinds uses cookies on its websites to make your online experience easier and better. By using our website, you consent to our use of cookies. For more information on cookies, see our cookie policy.