X hits on this document

Word document

SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and ... - page 12 / 76

238 views

0 shares

0 downloads

0 comments

12 / 76

SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability8

RAID

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 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_87jm.asp.

For general information on common RAID levels, see “RAID” in the MSDN Library at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_0m5g.asp.

Small-scale solution

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.

Figure 1

Microsoft Corporation © 2005

Document info
Document views238
Page views238
Page last viewedSun Dec 04 23:28:16 UTC 2016
Pages76
Paragraphs1372
Words23715

Comments