This article can also be found in the Premium Editorial Download "Storage magazine: The hottest storage technology for 2007."
Download it now to read this article plus other related content.
Configuration parameters set within the database application, the database server OS and the storage array significantly affect overall ERP application performance. In most cases, the configuration parameters are established by administrators from different functional groups, each with their own goal. Without appropriate coordination, the ability to protect ERP data and the overall performance of the ERP application for end users is compromised.
In this three-part series, we'll review how to effectively configure and manage the storage infrastructure to support a production ERP application. This article focuses on establishing an efficient storage infrastructure for ERP apps.
A typical mission-critical ERP environment includes development, training, QA and production servers. Within the production environment, the ERP application has a production database server and multiple production application servers. Three-tier applications like SAP are architected to scale CPU and memory through the addition of more application servers, but there's typically only one database infrastructure. The I/O access for the database server to the storage infrastructure can set the performance characteristics of the entire ERP application. Our performance discussion will concentrate on how to appropriately configure the storage array, database server OS and database application to maximize I/O from the database server to the storage housing the data.
This was first published in December 2006