X hits on this document

Word document

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

321 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 views321
Page views321
Page last viewedWed Jan 18 04:55:08 UTC 2017
Pages76
Paragraphs1372
Words23715

Comments