SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability15
SAP NetWeaver Application Server Instances
1 to n commodity servers with 2 to 4 CPUs, each with 2-GB RAM per CPU core.
SQL Server 2005 Database Server / SAP Central Instance (CI) Server
2 servers, commodity or noncommodity, dual-core with up to 64 processors and up to 512-GB RAM.
Set to active-to-passive mode.
Eventually use pure SQL Server active-to-active clustering between the Productive Database Instance and Test Database Instance.
Clusters are networked storage configurations that are dependent on a shared storage infrastructure.
Per the vendor’s networked storage installation requirements.
Storage Area Network
Storage Area Network or, rarely, using locally-attached storage. Storage devices must be on a multicluster device according to the HCL.
SAP BW Storage Requirements
80 to 250 disks:
1 data file / processor core
Microsoft Corporation © 2005