Disk Partition for EHP4/Windows server 2008/SQL server 2008

[Former Member]

Hi All

What is the drive partition recommendation for EHP4 ERP6 on Windows server 2008 and SQL server 2008? I have checked the notes/ SAP Documents but have not find any information related with SAP recommendation on this. Please help.

I need the recommended partition size for SAP application , transaction log, SAP datafiles , MS SQL server installation files for DEV/QUA/Production

If you have a similar landscape for EHP4 , can you check in your DEV,QUA, Production set up and tell the allocated and used partition size for SAP application, transaction log, SAP datafiles, MS SQL server installation files.

Regards

Sahad

[markus_doehr2 · Accepted solution]

First: don't use partition, use separate disks (physical disks).

The normal way would be:

- you create a sizing project at http://service.sap.com/quicksizer

- your hardware vendor picks up that sizing and recommends a hardware and a setup of the filesystems

How much space you need for your environments depends on how you plan to use the system, amount of users, estimated amount of transactions etc. It's impossible to suggest here something without knowing anything about your environment.

Markus

[Former Member · Accepted solution]

Hi Mark

We have already done the sizing and gave the details to hardware vendor. We are using SAN for the datafiles , transaction logs, SAP application etc . We know the total space needed for SAP datafile . In HP SAN there they create partition and allocate space for each items like SAP application, transaction log etc.

How we can get drives instead of partition in SAN ? even if you assign a physical disk, how much should be the size of the disk for each?

Our Sizing output is 2,500 SAPS, 16 G.B , 500 G.B SAN space . etc.

Please advice,

Regards

Sahad

[markus_doehr2 · Accepted solution]

> How we can get drives instead of partition in SAN ? even if you assign a physical disk, how much should be the size of the disk for each?

Create a separate LUN on the SAN for each kind of disk, don't create one big disk and separate it using partitions.

> Our Sizing output is 2,500 SAPS, 16 G.B , 500 G.B SAN space . etc.

So I'd create a disk for

- database DATA (your estimated size)

- database transaction LOG (your estimated size)

- \usr\sap (about 75 GB - including transport directory if it resides on that machine)

Markus

[Former Member · Accepted solution]

Hi Markus

Thank you for the help.

>Create a separate LUN on the SAN for each kind of disk

You mean that a separate LUN for SAP datafiles of 500 G.B on raid 5, a separate LUN for transaction log of 80 G.B on raid 1, and a seperate LUN for SAP application for 80 G.B for EH4 production? Please confirm.

Can you share the current disk size for above components in your landscape?

>- database transaction LOG (your estimated size)

Sizing does not give you the details of transaction log.

Please advice on above.

[Former Member · Accepted solution]

Hello Sahad

As described by Markus and also, i want to share my company landscape information.

We are using HP SAN Environment with using the SAP SR2 SQL 2005 and Win 2003 on HP Itanium Processor.

We had reserved and present the following vdisk from the SAN Environment to the PRD server.

F:\DATABASE 600GB RAID 5 ( still 200 GB free ** we lived our system on 1 Aug 2007)

L:\TRANSACTION LOG 30GB RAID 1 ( Expanded up to the disk space ** make backup 4 times a day )

T:\TEMPDB 1GB RAID 1

K:\KERNEL 100 GB RAID 5 (30 GB Free ** updaing kernely and EW tools upon the latest availability)

Regards

Anwer Waseem

[Former Member · Accepted solution]

Hi Anwar

Is the ERP version is EHP 4 ? . Basically I want to know what difference of size EHP4 can bring to datafiles, SAP application etc.

Thank you

Sahad

[Former Member · Accepted solution]

No, We lived our system on SR1 with the initial DB size was 80GB then we upgraded our system by the SR3 in the EOY 2008.

We are Planning to move on EHP4 in the 1st Quarter.

Regards

Anwer Waseem