SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability8
mySAP with SQL Server 2005 architectures use common RAID levels including 1, 1+0, and 0+1, as shown in the diagrams later in this section. For the best performance with full recoverability, customers frequently use RAID 0+1. RAID 5 can be used as a lower cost alternative. The choice of RAID level is dependent on the workload and this choice can directly affect the way SQL Server 2005 performs.
Note that RAID levels greater than 10 (1 + 0) offer additional fault tolerance or performance improvements. However, systems using RAID 10 and greater tend to be proprietary. For more information about specific RAID system capabilities, contact the hardware vendor.
For more information, see “RAID Levels and SQL Server” in the MSDN Library at .
For general information on common RAID levels, see “RAID” in the MSDN Library at .
The small-scale solution for using mySAP and SAP BW with SQL Server 2005 typically has the following characteristics:
Support for 100 or fewer concurrent users, depending on the workload
A low SAP batch workload
No major differences between SAP products (mySAP and SAP BW)
This architecture is commonly used in small scale SAP development or test systems. See Figure 1.
Microsoft Corporation © 2005