X hits on this document

Word document

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

288 views

0 shares

0 downloads

0 comments

13 / 76

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

Architecture

Description

Server

SAP NetWeaver Application Server / SQL Server 2005 Database

1 commodity server having 2 to 4 central processing units (CPUs), each with 2 gigabytes (GB) RAM per CPU core.

2-GB random access memory (RAM) is assigned to support SQL Server 2005.

Failover Clustering

None

RAID

RAID 0+1, 1+0

Local Storage

mySAP Storage Requirements

For data files (assuming RAID 1 or similar):

4 partitions for each disk with 6 disks minimum

For transaction log (assuming RAID 1 or similar):

1 partition for each disk with 8 disks minimum

For tempdb and log (assuming RAID 1 or similar):

1 partition for each disk with 6 disks minimum

SAP BW Storage Requirements

For data files (assuming RAID 1 or similar):

4 partitions for each disk with 6 to 8 disks minimum

For transaction log (assuming RAID 1 or similar):

1 partition for each disk with 6 to 8 disks minimum

For tempdb7 and log (assuming RAID 1 or similar):

1 partition for each disk with 6 disks minimum

The recommended storage requirements for the data files and transaction log differ for mySAP and for SAP BW. The tempdb and log requirements are the same for either system.

7 tempdb is typically 1.5 times the size of the largest SAP fact table.

Microsoft Corporation © 2005

Document info
Document views288
Page views288
Page last viewedSat Dec 10 13:43:19 UTC 2016
Pages76
Paragraphs1372
Words23715

Comments