Database Performance Analyzer
Database and SQL query performance monitoring, analysis, and tuning
- Expert database and SQL query tuning advisors
- Identify database problems in real-time
- True root cause analysis
- Cross-vendor database support from a single interface
- Low overhead on monitored databases
- Integration with the Orion Platform
What’s new in Database Performance Analyzer v11.1
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 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.
- 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.
You can configure DPA to alert you when:
- An AG status becomes Partially Healthy and Not Healthy
- An AG failover occurs
- DPA evaluates status every 10 minutes instead of once an hour.
- There are now three statuses instead of two.
- The database instance dropdown menu displays a status indicator.
- 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.
- Icons have been updated.
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.
Improved wait time status meter
The following improvements have been made to the wait time status meter on the DPA homepage:
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.