ADSM-L

FW: SAP and 3494 performance.

2001-03-21 07:41:18
Subject: FW: SAP and 3494 performance.
From: "Norback, Jan" <Jan.Norback AT NL.ORIGIN-IT DOT COM>
Date: Wed, 21 Mar 2001 13:41:39 +0100
Hi,
Following is a log (slightly altered in size and names)for SAP backup. AIX
4.3.3 on the SAP system and the TSM 4.1.2 server. ESS SAN attached disks,
3590-E SAN attached (2) tape drives. All backups over Gbit Ethernet today
with ~20MB/s and session.

Note:
-Multiplexing is still using 4 disks to read from (kept from our SSA days).
Multiplexing has got nothing to do with tape drive allocations on the TSM
Multiplexing has got nothing to do with tape drive allocations on the TSM
server and you might need it to get enough disk to read from so that each
session can fully use the tape drives speed .
-2 parallel sessions thus 2 drives allocated for the backup (redologs goes
to disk)
to disk)
-No client compression for SAP backups! Never ever unless you have a very
good reason (CPU heavy).
good reason (CPU heavy).
-RL compression gives me 1.32, this can differ a lot depending on the DB, in
production we usually see below 2, mostly between 1.2-1.5. RL-compression is
production we usually see below 2, mostly between 1.2-1.5. RL-compression is
CPU light.


BR061I 383 files found for backup, total size 523133.822 MB.
....

                       Tivoli Data Protection for SAP R/3

          Interface between SAPDBA Utilities and Tivoli Storage Manager
                 - Version 2, Release 7, Level 25.1 for AIX LF -
        (c) Copyright IBM Corporation, 1996, 1999, All Rights Reserved.

                           Program Number : 5799-QZG



  -- Parameters --
Input File         : /oracle/SIDX/sapbackup/.bdexttba.lst
Output File        : stdout
Profile            : /oracle/SIDX/dbs/initSIDX.utl
Configfile         : /oracle/SIDX/dbs/initSIDX.bki
Manual sorting file: disabled
Tracefile          : none
Traceflags         : disabled
Parallel sessions  : 2
Multiplexed files  : 4
RL compression     : enabled
TCPWait            : 3 sec.
Retries to  ADSM   : 3
Retries for files  : 3
Exit on error      : disabled
BATCH              : enabled
Redologcopies      : N/A
Versioning         : enabled
 Current Version   : 623
 Versions to keep  : 7
 Delete Versions   : <= 616
Backup Type        : file
SNMPTRAP           : disabled
Performance Monitor: disabled
ADSM log server    : host 'XYZ', level 'WARNING'
ADSM server        : XYZ with 2 sessions configured, using 2 sessions
 TSM client node  : SIDX
 Server-Version    : 4.1.2.0
 Server Host IP    : X.Y.Z.U
 Server Host name  : HOST
 Server Type       : AIX-RS/6000
 Sign-in id name   : SIDX
 Compression       : client determined
 Archive deletion  : allowed
 Days for backups  : Sun Mon Tue Wed Thu Fri Sat
 Backup mgmt class : SAP_ON_OFF
 Archiv mgmt class : SAP_LOG_1 SAP_LOG_2

BKI0005I: Start of backint program at: Wed Mar 21 00:16:54 2001.
BKI0013I: 383 Objects to backup.
BKI0008I: Number of bytes to save: '510.873 GB'.
......
BKI0020I: End of backint program at: Wed Mar 21 02:55:03 2001.
BKI0022I: Average transmission rate was 196.532 GB/h (55.902 MB/sec).
BKI2019I: Compression ratio for backup was 1.32.
BKI0021I: Elapsed time: 02 h 38 min 09 sec.
....

Regards,
Jan Norback

Atos Origin-IT (MS/DS/OSS Unix)
VA-173, PO-box 218, 5600 MD Eindhoven, The Netherlands
Groenewoudseweg 1 5621 BA Eindhoven, The Netherlands
Email: Jan.Norback AT Atosorigin DOT com
Tel: +31 (0)40-2780289
Mobile: +31 (0)6-25233507
Fax     : +31 40 2783962