Database Growth

[Former Member]

hi to all

could you tell me the benchmark SAP Database growth for monthly and yearly

regards

Ramesh

[Former Member · Accepted solution]

Dear Ramesh,

Its depen on your business requirement.

But you can use 20GB/month for standard installation.

More than that you can consider get SAP service "SAP Data Management", SAP will help you to analyst the data by using 4 method:

1. Data avoident

2. Data summary

3. Data Archive

4. Data deletion

That service can help you to reduce the monthly growth also you database size.

Hope this help.

Regards,

Fendi

[Former Member · Accepted solution]

hi

thank you for your reply. one more question i want to know,

while doing the Database instance installation, shall i kept OriglogA, OriglogB and MirrorlogA, MirrorlogB in different Drives.

thanks

Ramesh

[markus_doehr2 · Accepted solution]

>

> Dear Ramesh,

>

> Its depen on your business requirement.

> But you can use 20GB/month for standard installation.

What is a "standard installation"? Can you elaborate on this?

Markus

[Former Member · Accepted solution]

Ramesh,

Yes, it is good to keep mirror of redo log on different hard drive as per OFA(Oracle Flexible architecture). You have a better chances of surviving from disk failure.

Thanks

[Former Member · Accepted solution]

Hi Markus,

I mean if you dont have alot of customize table and and non default config that can generate more data.

Like our situation, we have alot of config and customize table that update from user exit. so the growth was not from SAP standard application but also from our customize.

So for our case 40GB/month growth still acceptable for use.

But for SAP they say 20GB was consider high (base on Data Management Report)

Regards,

Fendi

[Former Member · Accepted solution]

Hi Ramesh,

Yes you should keep that folder on different disk for security reason and performance reason.

But if you can't provide the disk as much of your redo log, than you can use only 2 disk (RAID1) for the redo log

with setting

RedoLogA + mirrlogB in Disk1

RedoLogB + mirrlogA in Disk2

so incase one of the disk faild, you still have 1 complete set of redolog A+B (one is mirror)

Regards,

Fendi

[markus_doehr2 · Accepted solution]

We have about 2 - 5 GB per business day - depending on what´s going on in the system.

Markus

[Former Member · Accepted solution]

Hi Markus,

This statement I copy from Data Management Verification Report:

SAP recommends that you implement a Data Management and Data Archiving Strategy for systems or system

landscape solutions with a database volume > 500 GB and/or monthly database growth rates > 30 GB supported

by the SAP Data Volume Management Services.

[markus_doehr2 · Accepted solution]

Interesting

We do archiving and we don´t have any huge problems with the system because of the size. I´ve seen systems growing much more and I really wonder where SAP has those numbers from....

Markus

[Former Member]

not answered