Solving Database Performance Problems with Better Storage Performance -- Another Kusnetzky Group Paper

Share Article

Database performance problems can cause application slow-downs or failures. These, in turn, can cause the organization to lose revenues, lose customers or fail to meet its goals in other ways. Improving storage performance can solve these problems

Kusnetzky Group, Inc. today posted Solving database performance problems with better storage performance, another position paper intended to review the forces changing the market for information technology, virtualization and cloud computing. These position papers are written by the well known software analyst, Daniel Kusnetzky, who is the Kusnetzky Group LLC’s Distinguished Analyst and Managing Director, and the principal author of ZDnet's “Virtually Speaking.” To download this white paper, go to “Solving Database Performance Problems with Better Storage Performance.” (http://www.informationweek.com/whitepaper/Storage/Storage-Systems/solving-database-performance-problems-with-better-wp1297705267238;jsessionid=DHVY1ENBQJV4VQE1GHOSKH4ATMY32JVN?articleID=180100006)

Paper Overview

Database management systems are some of the most complex pieces of software deployed in an organization’s datacenters. Database performance problems can cause application slow-downs or failures. These, in turn, can cause the organization to lose revenues, lose customers or fail to meet its goals in other ways.

The Database Performance Problem

Modern database engines are made up of multiple processes, each serving a different purpose. These processes may be deployed on multiple systems and manage huge amounts of structured and unstructured data.

Furthermore, each database engine manages storage differently. Some treat data as a series of tables, some as a number of records and still others deal with data as “memory images.” Each database engine also manages access to the data differently. Some maintain extensive indices allowing very rapid access to specific items, but this requires the database engine to do more work maintaining those indices if a data item is modified or deleted.

Database performance depends upon a large number of factors including the performance of the processor(s), the size and performance of system memory, performance of storage adapters, performance of networks and storage devices. In this paper we will be focusing on the problem of I/O bottlenecks.

Any database can be negatively impacted by data access bottlenecks (“I/O wait”), which will result in slow application response time. I/O wait is the total duration that the working processes of a database or application session are blocked while waiting for I/O operations to complete. High I/O wait can mean that your storage device is providing “unacceptable” services to your database or other mission critical applications, resulting in low customer satisfaction and employee productivity.

What Can be Done?
This paper discusses how faster storage that reduces latency and improves data throughput can have a direct impact on database performance. This, in turn, often supports a dramatic improvement in application performance

About Kusnetzky Group

Kusnetzky Group LLC brings decades of experience in all areas of the solution life cycle. It offers deep expertise in research, product planning, product development, and product marketing in the following areas: Virtualization technology, System software, Cloud Computing, Mobile computing solutions, and both Collaborative and personal productivity applications, Developing and deploying Web-based viral marketing campaigns. For more information, please visit http://www.kusnetzky.net.

# # #

Share article on social media or email:

View article via:

Pdf Print

Contact Author

DAN KUSNETZKY
Visit website

Media