Determine which database performance tools best mitigate bottlenecks

Last updated:August 2016

Editor's note

In today's database-centric world, it isn't always apparent what caused an application to slow down or, worse yet, a complete system outage. But it's imperative that these problems be fixed as soon as possible, and every second counts. When database performance suffers, internal business processes slow down and your end users complain. And as if this wasn't bad enough, customers who get fed up waiting for web applications to respond will seek out your competition.

Database performance tools help database administrators (DBAs) and other systems professionals identify the source of problems and provide ways to solve them. They can also be used to improve the response time and efficiency of your databases and the applications that run on them, which can eliminate unplanned downtime. And database performance software can actually help DBAs be proactive by mitigating or preventing performance issues from occurring.

According to author Craig S. Mullins, one of the most compelling features of database performance tools is their ability to collect metrics on database usage and identify specific database problems -- as and when they occur. Instead of having to hunt for the root cause of the problem manually, the DBA can use the software to quickly examine the database system and applications and then diagnose potential problems.

To help you justify the purchase of a database performance tool, this buyer's guide explores the types of bottlenecks organizations face and how database performance tools can be used to address them. It delves into the three types of performance tools and their capabilities: database system monitoring and management tools; database structural monitoring and management products; and SQL monitoring and management software. Finally, to help you navigate through the technology selection process, we examine the leading tools in each category, comparing their features as well as the number of database management systems (DBMSes) they manage, their cost, metrics and support. 

1Assessing the need for a database performance tool

There are a variety of factors that can slow down even the best database applications, and identifying the cause of the bottleneck can be difficult and time-consuming. Database performance tools can help simplify the process.

2Considerations for selecting database performance software

Here, we uncover the most important capabilities of the different types of database performance management tools.

3Choosing a database performance tool to fit your needs

The analysis and comparisons provided here will help you select the right database performance tool from the leading products on the market.

4The leading database performance tools

Here, we take an in-depth look at the leading database performance tools offered today as well as the factors that differentiate them from one another.