cancel
Showing results for 
Search instead for 
Did you mean: 

30 systems sepate DB from Application part consolidate all smaller DB

Former Member
0 Kudos

Hello

We have around 30 systems. (IT-U, ECC, BW, PI, SOLMAN, CRM, EP,...). I am desperately trying to find a document which clearly says there is no need to separate DB from Application part.

Maybe an example of a company with situation like ours

Namely from Our HW and Oracle "specialists" I am advised to sepate DB from Application part for each(even small system). In addition I am "advised" to consolidate all smaller DB which I have not seen at any SAP customer.

I am trying to find an document which clearly states it is a nonsence

should anyone see such documents please be so kind

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I am trying to find an document which clearly states it is a nonsence

Ok, i am only listing points against it.

Against MCOD:

- having different SAP products in one database can be a problem when for example the BW needs a different setting than the PI

- SAP schemas are huge regarding data size, number of tables, so MCOD never was a big success. You are also complicating maintenance on the database, if one of the systems is 7x24, then you cannot do a database upgrade on another that has only 5x8 uptime requirements.

- if an error happens one SAP system, and you have to do a restore with point in time recovery ALL systems in that database have to be reset!

Against distributed installation (database <-> sap application server):

- in a distributed installation, the availability decreases, either the application server OR the database server OR the network in between can fail-> more unplanned downtime.

- the performance of a distributed installation cannot be faster compared to a single system installation, because of the additional network time

Against both:

- Simple system landscapes work best. If ever possible stick to standard/basic installations, they are known to work. Complicating your landscape can increase costs, increase needed knowledge to admin staff, cause more errors / services disruptions.

I don't think there will be one single document stating this is nonsense. Try to get the reasons, why you are asked to do it. Then we can see how valid they are.

Cheers Michael

Edited by: mho on Dec 17, 2010 12:41 PM

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello

Thank you for reasonable answer

former_member218672
Active Contributor
0 Kudos