ADSM-L

Re: How many drives are you using when you are running TDP for R/ 3 and backing up SAP Database? Urgent!

2003-08-15 09:50:06
Subject: Re: How many drives are you using when you are running TDP for R/ 3 and backing up SAP Database? Urgent!
From: "Hooft, Jeroen" <Jeroen.Hooft AT ATOSORIGIN DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 15 Aug 2003 15:46:10 +0200
Hola

That should do the trick, I think.
If the line to the drives is not the bottleneck anymore, the system and/or
drives will become.

The performance of LTO-drives differs a lot in my LTO-environment. Goes from
8MB/s upto 30MB/s, but I think that's the result of a poorly setup of the
SAN and the fact that I have windows-clients. I don't know what your current
performance is on the LTO-drives, but from those figures you should be able
to calculate the needed amount of drives.

Some other tips for fast SAP/Oracle backups:
* There is an option SORT_FILE in the utl-file. This gives you the
possibility to specify in which order the SAP-datafiles are backed up. In
this way you can make sure that the read of disks is balanced over the
adapters (I never implemented that because it's very labor-intensive and
risky. If you forget one file it won't be backed up)
* If the connection to the drives is wide and fast enough, you might
consider turning off RL_COMPRESSION. We had faster backups after turning it
off, because the client had less load.
* Play with multiplexing. With several paths to the ESS, changes in this
setting gave us major differences in backuptime.


Jeroen



-----Original Message-----
From: Juan Jose Reale [mailto:juan.reale AT AES DOT com]
Sent: donderdag 14 augustus 2003 23:09
To: ADSM: Dist Stor Manager; Hooft, Jeroen
Subject: RE: How many drives are you using when you are running TDP for
R/ 3 and backing up SAP Database? Urgent!
Importance: High


        Hello!

        Yes,  I am using LAN-Free backups via SAN,  but  I  have one HBA
(Fiber Channel Adapter - 100 MB/sec) for accessing drives and other 4 FCAs
for accessing disks (SHARK).   We have two switches (directors) ED-500 and
2 switches MC-Data ES-1000.

        I think we have to get other  three more FCAs for accessing better
speed of drives.  Is it correct?   It means in the following:  if we will
reach 240 MB/sec (80 * 3) via 3  FCAs,  that is  864.000 MB / h.
  1700000 / 864000 = 2 hours. If we will use 3 FCA to our drives.  Is it
correct?
        I hope again your comments.
        Thank you very much.
        Juan R.

-----Mensaje original-----
De: Hooft, Jeroen [mailto:Jeroen.Hooft AT ATOSORIGIN DOT COM]
Enviado el: Jueves, 14 de Agosto de 2003 11:04 a.m.
Para: ADSM-L AT VM.MARIST DOT EDU
Asunto: Re: How many drives are you using when you are running TDP for
R/ 3 and backing up SAP Database? Urgent!


Hi

Assuming it are LANFree backups, via how many HBA's are you accessing your
drives (and disks)?
I think the HBA and or the SAN-switch will be the bottleneck (if you have
1Gbit/sec adapters/ports).
Let's say you will reach 80 MB/s via 1 HBA, that's 288.000 MB/h
1700000/288000 = 6 hours if you use 1 HBA to your drives and many tapedrives

This assumes that you have a seperate HBA for disk and that there is hardly
any other traffic on that part of the SAN.

If you can reach each individual drive (or each 2) via different fabrics,
things change.
Then one can easily calculate the amount of drives from the specifications
of the drive.
Let's say these drives can reach 30MB/s. Then one needs at least 4 drives to
finish in 4 hours.

We reach our 3590 drives via different fabrics and get with 2 drives a
throughput of 250 GB/hour for our SAP-backups (AIX).

Maybe you should have a look at flashcopy and/or "TDP for ESS for SAP/R3".

Regards Jeroen



-----Original Message-----
From: Juan Jose Reale [mailto:juan.reale AT AES DOT COM]
Sent: donderdag 14 augustus 2003 15:52
To: ADSM-L AT VM.MARIST DOT EDU
Subject: How many drives are you using when you are running TDP for R/3
and backing up SAP Database? Urgent!
Importance: High


  Hi everybody!

        We are going to purchase a LTO Ultrium Ultrascalable tape library
3584 model L32,  but  I don't know  yet how many drives we need for running
TDP for R/3 (Oracle) on IBM 6M1 RS/600 in under 4 hours.
        There are 8 CPU's (750 Mhz) with memoria real = 10 GB.  The SAP
database's size is about 1.700 GB  or  1,7 TB.   The TSM Server 4.2.2.10 are
running on IBM MB80 RS/600. The TSM server is on the separate physical
server from SAP database.
        We are using disks SHARK IBM.

        So, please tell me how many drives recommend to allocate in Library
3584 in order to take a SAP database backup in under 4 hours.

        Thanks in advanced.
        Juan R.

________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs service.

________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs service.

________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs service.