UNSOLVED

sainath_pawar

updated

12 years ago

0

526

April 6th, 2015 22:00

Backup Time


Hi All,

We are taking daily full backup of SAP database (size : aproximately 2TB) & backup time is 3-4 hours.

After the below activity on one of the SAP database, backup time for that database has been redued to 1- 1:30 hours (However backup size is same)

1. SAP team has changed parameters which will optimize the application performance.

2. added 12GB of memory to CI(Application + Database server) and removed 6GB each from other two application servers.

From EMC networker perspective we have not done any changes.

So can any one help us to uderstand is there any co-relation between the above SAP activity on that database & backup performance.

Thanks & Regards

Sainath

  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    285

    0

    Posted April 7th, 2015 01:00

    It depends what 1) is.  For example, it is enough to change parameters in utl file (though that is NW config) to gain performance out of the box.  If reads are accomplished faster now, then backup will be faster.

  • sddc_guy

    159 Posts

    285

    0

    Posted April 7th, 2015 02:00

    General answer ( not SAP related ):

    The More Memory a Daabase has, the more it can Perfporm and Utilize the System ( CPU / IO )

    That may affect Backup as well

  • 285

    0

    Posted April 7th, 2015 02:00

    Hi Hrvoje,


    We have not done any changes in NW server.

    only the chnages which has been done from SAP side i.e application level & meomry of application server.

    and after that backup time has been reduced to half though backup data is same. which is very good.

    Can we say like that backup is taking very less time due to such kind of changes  from application side

    Thanks & Regards

    Sainath

  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    285

    0

    Posted April 7th, 2015 03:00

    I didn't say anything about backup server - profile file in on client.  I think you need to get clear understanding of what steps have been done on client and only then you can see what may or may not affect backup speed.  But obviously, any kind of optimization should trigger better (in general) performance stats.

    It is also not clear to me how you measure this as you keep talking about DB server + application nodes, but these two are separate entities and I assume you really wish to focus on DB side only (as application nodes are usually fastly handled as that is pure fs backup).