BACKGROUND IMAGE: iSTOCK/GETTY IMAGES
The SolarWinds Database Performance Analyzer is a database performance monitoring and analysis tool for database administrators and application teams. It provides performance intelligence that pinpoints the cause of bottlenecks, provides expert advice and reduces the overall cost of database operations.
The response time analysis feature of Database Performance Analyzer can be used to provide operational intelligence about a database's performance over time. It tracks every query in every active session and captures the wait events/types that impose delays on the queries.
Database and application teams can use SolarWinds' Multi-Dimensional Performance Analysis to gain a comprehensive view of database performance by combining queries, wait times, resources, sessions, time and other vectors.
Versions of the product are available that support Oracle Database, Microsoft SQL Server, IBM DB2 for Linux, Unix, Windows (LUW), SAP Adaptive Server Enterprise, MySQL and Amazon Relational Database Service. Database Performance Analyzer can monitor hundreds of instances from a single view whether on premises, virtualized or in the cloud.
Key features of Database Performance Analyzer
Dynamic baselines identify anomalies to monitor, providing detailed metrics and years of history. The graphical display makes it easy for anyone -- DBAs, managers and developers -- to see the trends and patterns that tell the complete performance story.
SolarWinds Database Performance Analyzer requires no agents and imposes minimal impact on monitored databases. The product is a Java application that runs on a dedicated Windows, Unix or Linux server. An SQL Server or Oracle repository acts as the data warehouse for collecting performance data over time. Users interact with Database Performance Analyzer through a browser on a computer, tablet or mobile device.
Additional components and integrated tools
DPA Central, referred to by SolarWinds as a monitor of monitors, provides a central view of multiple Database Performance Analyzer instances. This is especially useful for companies that manage multiple large data centers and that want to monitor thousands of database instances.
SolarWinds offers an optional, free component that integrates SolarWinds Database Performance Analyzer data into the SolarWinds Orion interface. This provides an end-to-end, application-centric view of health and performance across transactions, application metrics, physical and virtual server data and storage when used with other SolarWinds Orion-based products.
SolarWinds offers IT monitoring and management tools that complement Database Performance Analyzer. SolarWinds Server & Application Monitor and SolarWinds Storage Resource Monitor provide system/server and storage performance details. Additionally, the SolarWinds Log and Event Manager security tool includes SQL auditing capabilities to detect database security issues, including SQL injection attacks, failed login attempts and deletion of logs.
Licensing and support
SolarWinds Database Performance Analyzer is licensed per instance. Pricing starts at $1,995 USD for MySQL, SQL Server and Oracle Standard Edition; $2,845 with virtualization capabilities; and $3,495 USD for Oracle Enterprise Edition, DB2 and SAP ASE. Discounts are available based on the number of total instances monitored. The first year of product maintenance and support is included with the purchase of Database Performance Analyzer.
How you can avoid database performance issues and outages
Evaluating your organization's database performance management functionality needs
Which database management system is right for you?