Storage - SAP NetWeaver on AWS

Storage

The following table lists the main directories for SQL Server database.

Main directories for SQL Server database
Usage Directory Description
Database data files

<drive>:\<SAPSID>DATA0

<drive>:\<SAPSID>DATA1

…..

<drive>:\<SAPSID>DATA<N>

Directory for SAP database data files
Database transaction log files <drive>:\<SAPSID>log<N> Directory for SAP database transaction Log
Tempdb data files <drive>:\Tempdb Directory for temporary database data files
SQL binaries and other data files <drive>:\Program Files\Microsoft SQL Server Directory for SQL Server program files and master, msdb, and model data files

Amazon Elastic Block Store (Amazon EBS) volumes are designed to be highly available and reliable. Amazon EBS volume data is replicated across multiple servers in an Availability Zone to prevent the loss of data from the failure of any single component.Due to this built-in protection, you don’t have to configure RAID 1 for volumes containing database transaction log files, tempdb data files, SQL binaries, and other data files.

We also do not recommend RAID 5 for database data files on AWS due to following reasons.

  • Volumes are replicated within Availability Zone by default.

  • Parity write operations of RAID 5 consume some of the IOPS available to your volume and will reduce the overall IO available for database operations by 20-30% over RAID 0 configuration.