Skip navigation

Product Blog

December 2017 Previous month Next month

We’re happy to announce the release of SolarWinds® Storage Performance Monitor, a standalone free tool that provides a consolidated view of all your storage array’s performance.

Designed for storage and systems administrators in organizations of any size, Storage Performance Monitor gives your team insight into total IOPS and throughput on storage pools, LUNs, and NAS Volumes.

Arrays supported by Storage Performance Monitor Free Tool:

  • Dell EMC Isilon
  • Dell EMC Unity
  • Dell EMC VNX / CLARiiON
  • Dell EqualLogic PS Series
  • IBM DS-8000
  • IBM FlashSystem A9000
  • IBM FlashSystem V7000/v3700
  • NetApp AFF series
  • NetApp ONTAP
  • PureStorage

 

The Storage Performance Monitor free tool allows you to add as many storage arrays as you wish. Simply click the “ADD STORAGE ARRAY” button, select the appropriate array type, and provide your connection details. Once you’ve added your array to Storage Performance Monitor free tool, it will load polling interval, discovery interval, and thresholds from global settings. You can edit these thresholds locally – per entity, by clicking the vertical ellipsis button.

You can then fine-tune your thresholds for this entity. If you do not wish to monitor it, simply keep the threshold empty. You won’t then get any notifications about this entity.

What else does Storage Performance Monitor do?

  • Allows you to add as many arrays as you wish
  • Creates a notification when any of the following conditions are met:
    • a metric exceeds a threshold,
    • the tool cannot connect to the array,
    • the array topology changes.
  • Can write all notifications into Microsoft Event Log.

 

For more detailed information about the Storage Performance Monitor, please see the SolarWinds Storage Performance Monitor Quick Reference guide here on THWACK®: https://thwack.solarwinds.com/docs/DOC-192403

 

Download SolarWinds Storage Performance Monitor: https://www.solarwinds.com/free-tools/storage-performance-monitor

 

For more advanced storage monitoring, try the evaluation version of Storage Resource Monitor, which gives you these features in addition:

  • Store historical data
  • Monitor hardware health
  • Monitor additional performance metric – storage latency
  • Monitor storage capacity
  • Map storage to hosts/VMs/applications
  • Alerting
  • Reporting
  • runs as a Windows service
  • Web front end

If you're one of the many customers that tried the beta or release candidate, you've already seen many of the exciting new features in SAM 6.5. For the rest of you, here are more details about what's new:

 

Azure Cloud Infrastructure Monitoring

Just as SAM 6.4 directly accessed the world's largest cloud, SAM 6.5 expands your ability to leverage multi-cloud further by adding support for Microsoft Azure accounts in addition to Amazon AWS.  While Amazon Web Services remains the largest cloud infrastructure provider, Microsoft is growing in this market at an incredible rate.  And many customers have a footprint in both.  Now you can see Azure or AWS accounts, or a mixture of both in the same view.

Cloud-related enhancements include:

  • Add or edit your AWS/Azure Account using new UI

  • Choose Instances/VMs for AWS/Azure Accounts
  • Poll Azure VMs for performance metrics
  • A single Cloud Summary page displays data for instances/VMs for multi-cloud environments

  • Monitor Azure VMs as Orion nodes to leverage the extended features of the Orion Platform and SAM for application and OS monitoring, including expanded metrics

PerfStack 2.0 — New Features and Improvements

  • Navigate directly from Application Detail pages to predefined sets of application monitor metrics

  • Use pre-defined links from these pages or create your own custom PerfStack charts from a broad range of metrics such as these from the Azure cloud:

  • Zoom into PerfStack charts to view more details for a selected time period
  • Alert visualization improvements
    • Each individual alert start/end time is now visualized separately in PerfStack
    • Existing aggregate alert visualization against an object is retained
  • Export PerfStack data to Excel
  • Share PerfStack functionality to make it more discoverable with new Share button
  • For more on PerfStack improvments, see Orion Platform 2017.3 - PerfStack New Features & Improvements

New Orion Installer

  • Install and upgrade one or more Orion Platform products simultaneously
  • Modern interface with a simplified design and intuitive workflow
  • Download and install only what is needed
  • Reduces download size and accelerates installation
  • For more on the Installer improvements, see New Installer Upgrade Experience

Other Improvements

  • New SAM templates for Microsoft Office 365 are included out of the box.  Microsoft is the leader in Software as a Service, and Microsoft Office 365 is gaining adoption with companies of all sizes.
  • Linux Agent for ARM-based devices such as Raspberry Pi to help you manage your Internet of Things (IOT)
  • Updated SAM templates for many Microsoft products
  • Search function integrated into global navigation
  • Improved dashboard view customization and Manage Nodes page
  • Support for High Availability (HA) 2.0 including multi-subnet deployments (WAN/DR)

 

What Else?

Don't see what you are looking for here? Check out the What We're Working On Beyond SAM 6.5 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 Server & Application Monitor Feature Requests

If you are using Orion, I am sure you have already heard of PerfStack (aka Performance Analysis), SolarWinds' Drag & Drop Answers to Your Toughest IT Questions.  DPA did not make the first cut of PerfStack, but I am happy to announce that with the release of DPA Integration Module 11.1, you can now see DPA goodness in PerfStack too!!! Imagine expanding Using PerfStack with WPM and SAM to Troubleshoot Web Performance Issues to include database and query wait time!  Answer the question "Is it the database or the application?" in just a few clicks, pulling in whatever data you need from both DPA and Orion!

 

 

PerfStack Support for Databases monitored by DPA

DPAIM 11.1 exposes DPA data already available in other Orion views, but also adds some new ones as well! Data includes:

  • Total Wait Time
  • Wait time by dimension (SQL, Wait Types, Programs, Users, etc.) with drill downs to SQL text and Wait Type descriptions
  • Database metrics
  • VM metrics
  • Custom metrics (yes, even the custom metrics!)

 

Data History and Granularity

PerfStack is able to show all the data available in DPA. So if you have 5 years of history in DPA, you'll see it in PerfStack. As you drill down in PerfStack, you'll get to more granular data (down to 1 second wait time). PerfStack will choose the best granularity for the time range of your current view, and then adjust accordingly as you zoom in or out.

 

Stacking Data

PerfStack allows you to stack different wait time dimensions in the same view to help you solve problems quickly. For example, do you want to know who is writing those bad queries? Just stack SQL and user dimensions into one view and look for the correlation.  You can also stack dimensions from different databases - even if they are on different DPA servers.

 

Data Explorer

Even more DPA data is available in PerfStack's Data Explorer function. The Data Explorer lets you drill down and view the details of the wait time dimension you've highlighted in PerfStack. All Wait Time dimensions will show you a list of metrics ranked by total wait time. but a couple dimensions show extra information:

  • Total Instance Wait Time (SQL) will show you the SQL text, letting you find the query causing the issue.
  • Wait Time by Wait Type will show you descriptions of the Wait Type, helping you understand why your queries are waiting.

 

Data Explorer - Query Search

When you drill into the Data Explorer for Total Instance Wait Time (SQL), you'll see the SQL text for the queries with the most Wait Time.  However, you can search the text listed in the Data Explorer - say a specific table, group by or other parameter - to further filter the result set.

 

Predefined PerfStack Views for Databases

Every database displayed in Orion via DPAIM has a predefined link to a default PerfStack view, which will include both wait time and key metrics for the specific database.

 

Adding Database Data to PerfStack

To add database data to PerfStack, click Add Entity then scroll and select Databases Instance.

PerfStack will list all databases from all integrated DPA servers.

Once you've selected an instance, you can choose multiple wait time metrics to add to PerfStack.

Once you've added wait time metrics, selecting an area will allow you to drill to additional information on some metrics: SQL text (for Total Instance Wait Time) and the wait type description (for Wait Type).

To see a fully operation PerfStack example, check out this PerfStack Application to Database Mapping in the Orion Demo Site.

 

New Resource - Blocking & Deadlocks

A new resource available for every instance monitored by DPA will show you blocking (all databases) and deadlocks (SQL Server only), to let you quickly see if the source of a database problem is blocking or deadlocks.

The resource has three tabs to show which queries are waiting the most (Top Waiters), which queries are blocking the most (Top Root Blockers) and if there are deadlocks.

Clicking on the SQL hash will get you a query detail popup, with a link to the DPA historical view for that SQL.

 

Improved Resource - All Databases Instances

When we first created the resources for the DPA Integration Module, we tried to communicate as much information as possible, combining DPA wait time and performance data as well as data in Orion.  However, with so much information, it made it too difficult for users to quickly answer the question "is the database having a performance issue".  Yes, memory may be high, but if users aren't waiting on queries any longer than normal, then there isn't really a "performance" issue.  Based on this feedback, we've made a few changes:

  • In the last release (DPA 11.0), we changed the status shown in Orion to reflect DPA's wait time status only
  • In DPA 11.1. we've simplified resources to only show wait time status and not the status of advisors or metrics (CPU, Memory, etc.)
  • Wait time status now has three states (green, yellow, red) instead of two (green, red)

Basically, we want to make it really clear if there is a problem with the database performance issue (i.e. high wait time) before you drill down to additional data.

 

Database Summary View - All Database Instances Resource

For databases monitored by DPA, the status is determined by the wait time status from DPA, regardless of other indicators in DPA or Orion. For databases monitored by Orion but not DPA, the Orion status is shown.

The new resource has simple filters at the top, allowing you to select one or more statuses.  In this case I've filtered the resource to only see database instances with a red or yellow status.

Other resources have been improved as well, see the DPAIM 11.1 Release Notes for more information.

 

Support for SQL 2017, Oracle 12.2, MariaDB and more...

As usual, all the databases that DPA supports you'll see in Orion too.  Here are the newest databases supported by DPA:

  • 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

See a full list of Database versions you can monitor with DPA.

 

DPAIM for ALL DPA Customers!

In the past, since DPAIM was an "integration" module, it was not available as a standalone module, meaning you needed to own another Orion product to use it.  However, with the addition of PerfStack support, we wanted to make sure all DPA customers could enjoy the benefits of DPAIM and Orion too.  So now, DPAIM is a standalone module, and doesn't require to be installed with another Orion product.   All DPA customers can now install the DPAIM module and take advantage of the great features of the Orion platform.

 

How do I get the DPA Integration Module?

If you own DPA, you can get DPAIM 11.1 multiple ways.

  • If you have a SAM installation, when you upgrade to v6.5, DPAIM 11.1 module will be installed and ready to use.
  • If you have other Orion-based products installed (NPM, VMan, SRM, etc.) but not SAM, you can download DPAIM from the Customer Portal and install it on your Orion server.
  • If you own only DPA but no other SolarWinds Orion product, you can take advantage of DPAIM too. Simply download it from the Customer Portal and install the DPA Integration Module (DPAIM) on another server.  If you are using a SQL Server for your DPA repo, you can use the same one for DPAIM.  If not, you can opt for SQL Express bundled with the DPAIM installer.

Once you have DPAIM installed, follow these instructions to integrate it with DPA.

 

But wait, there's more!

See everything else that made it into the release in the DPAIM 11.1 Release Notes, including:

  • Improved Instance View - Database Response Time Resource
  • New Query Popup, with formatted SQL
  • Compatibility Checker

 

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.

Filter Blog

By date: By tag: