Empowering database professionals

Database Performance Analyzer 12.0 introduces new query performance analyser and table tuning advisor for workload optimisation.

  • 6 years ago Posted in

SolarWinds Empowers Database Professionals with Powerful Tuning and Performance Insights

SolarWinds has introduced SolarWinds® Database Performance Analyzer (DPA) 12.0, a powerful database and query performance monitoring, analysis, and tuning tool built for many of today’s popular databases. The latest enhancements are designed to help database professionals quickly identify and pinpoint the root cause of slow database queries, and easily optimise database tables to help ensure the speed of business-critical applications that rely on them.

 

SolarWinds Database Performance Analyzer is designed to deliver deep visibility into the performance of databases in hybrid environments—on-premise, virtualised, and in the cloud. SolarWinds DPA provides actionable insights for database professionals through two brand-new features, Table Tuning Advisor and Query Performance Analyser.

 

Query Performance Analyser can assist users in pinpointing the root cause of slow SQL queries. Detailed query profile data is intelligently displayed in one view, which can reduce the amount of time spent sourcing and correlating information.

 

“Table Tuning Advisor answers about 99% of what I want to know,” said Dale Fanning, director, database & systems engineering, Regent University. “I think it provides all the data you would need to make a tuning decision.”

 

The Table Tuning Advisor is designed to proactively provide a solution to one of the most challenging aspects of database management: indexing. SolarWinds DPA Table Tuning Advisor helps identify and validate index opportunities by monitoring workload usage patterns, and then making recommendations to users of where a new index can help optimise inefficiencies.

 

“Databases are at the crux of application performance and a slow database often results in a slow application,” said Christoph Pfister, executive vice president of products, SolarWinds. “Solving application performance issues without deep insight into the database is a challenging endeavor at best. SolarWinds DPA 12.0 can help database professionals tackle performance problems more quickly and accurately with these new features, which are designed to identify exactly where to focus tuning and indexing efforts to optimise the performance of their environments and reduce manual processes.”

 

SolarWinds DPA is designed to provide seamless integration with SolarWinds network and systems tools, including Network Performance Monitor (NPM) and Server & Application Monitor (SAM). Integration with features like SolarWinds® PerfStack dashboard is built to provide additional blocking analysis support, which can help users discover where a blocking incident has occurred and the overall impact of the action, guiding informed future troubleshooting strategies.

Despite being published in late 2022 and coming into effect in January 2023, the second Network and...
Talent and training partner, mthree, which supports major global tech, banking, and business...
Renowned non-profit transforms and simplifies its IT operations and efficiency with NinjaOne.
Findings from the SolarWinds 2024 State of ITSM Report showcase several more effective methods for...
On average, only 48% of digital initiatives meet or exceed business outcome targets, according to...
Deployed in minutes without code or consultants, Freddy AI Agent delivers fast time to value,...
Splunk has released The State of Observability 2024 report in collaboration with Enterprise...
99.7% of organizations recognize AI's potential to overcome IT challenges and drive efficiency, but...