Sergey Nivens - Fotolia

Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Database bottlenecks put applications at risk if left untreated

Slowdowns in database processing can put a big crimp in business applications -- a corporate malady that database performance management tools are designed to help remedy.

Even in the big data era, with Hadoop clusters and Spark systems on the rise, databases remain the lifeblood of IT architectures in most organizations. As a result, database bottlenecks that cut off the timely supply of data to end users can cause the applications at the heart of business operations to stop beating normally. And that condition isn't conducive to long-term corporate health.

Database administrators (DBAs) and software programmers can take steps to avoid database performance issues. For example, in a series of three blog posts published in August and September of 2016, consultant Craig S. Mullins detailed 12 rules of thumb for writing good SQL code to help produce database applications that run efficiently. But, in a follow-up post, Mullins cautioned that those guidelines aren't a guaranteed cure for what can ail databases.

"Rules of thumb are great, but let's face it, we don't always follow them. And then we get performance degradation," he wrote. When that happens, he added, DBAs are saddled with the tough task of having to identify the root causes of performance problems and prescribe a treatment plan to resolve them.

That work can be done manually -- or with the aid of database performance management tools designed to automate monitoring of resource utilization and diagnosis of database bottlenecks. Such tools point to "locking, I/O, CPU and other problems as your applications are running," potentially streamlining the work required to get data flowing properly, Mullins wrote.

But there are different types of software that focus on separate aspects of the process. To help make sure you select the right tool, or tools, to meet your organization's particular database-doctoring needs, this buyer's handbook offers advice from Mullins on the key features and functions to look for across the different product categories.

Next Steps

Continue reading this buyer's handbook:

Examining the functions and features of database performance tools
To help you determine which tools your organization needs, it's important to review the primary features and functionality of the three database performance tools categories.

This was last published in April 2017

Dig Deeper on Database management system (DBMS) software and technology

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSQLServer

Close