SolarWinds released Database Performance Analyzer 12

SolarWinds, a leading provider of powerful and affordable IT management software, today announced the launch of SolarWinds® Database Performance Analyzer (DPA) 12.0, powerful database and query performance monitoring, analysis and customization tool built for many popular, popular databases. The latest enhancements are designed to help database professionals quickly identify and determine the root cause of slow database queries, and easily optimize database tables to ensure the speed of business critical applications that rely on them.

The SolarWinds database performance analyzer is designed to provide high visibility to the performance of databases in hybrid environments – in the field, virtualized and in the cloud. The SolarWinds DPA provides effective information for database professionals with two completely new features: Table Tuning Advisor and Query Performance Analyzer.

The Query Performance Analyzer can help users determine the root cause of slow SQL queries. Detailed query profile data is intelligently displayed in a single view, which reduces the time spent searching for sources and correlating information.

“The table tuning advisor answers about 99% of what I want to know,” said Dale Fanning, director of database development and systems development, Regent University. “I think that he provides all the data necessary to make a decision about setting.”

The table tuning advisor is designed to proactively address one of the most difficult aspects of database management: indexing. The SolarWinds Advisor, DPA Table Tuning Advisor, helps identify and test index capabilities by tracking workload patterns and then advising users where a new index can help optimize inefficiencies.

“Databases are on the verge of application performance, and a slow database often leads to a slow application,” said Christoph Pfister, executive vice president of SolarWinds products. “Solving application performance issues without deep understanding of the database is a challenge at best. SolarWinds DPA 12.0 can help database professionals quickly solve performance problems with these new features that are designed to pinpoint where to focus on customization and indexing efforts to optimize the performance of their environment and reduce manual processes.”

The SolarWinds DPA is designed to provide seamless integration with SolarWinds network and system tools, including Network Performance Monitor (NPM) and Server & Application Monitor (SAM). Integration with features such as the SolarWinds® PerfStack™ toolbar is built to provide additional support for lock analysis that can help users find out where the lock-in incident occurred and the overall impact of this action, guided by information on future troubleshooting strategies.

SolarWinds DPA can be deployed on Windows or Linux, and it controls physical and virtual databases located on the background or in the cloud, including Microsoft® SQL Server®, Oracle®, MySQL®, MariaDB®, IBM® DB2® for Linux, UNIX® and for Windows (LUW), SAP® Adaptive Server Enterprise (ASE) SAP, as well as platform-like service (PaaS) databases, including Microsoft Azure® DB, Amazon® RDS and Aurora.

Detailed Review and System Requirements Database Performance Analyzer