cancel
Showing results for 
Search instead for 
Did you mean: 

Migration from Oracle to MaxDB

Former Member
0 Kudos

Hi All,

We want to migate from Oracle to MaxDB.

What are the possible test or procedures can do before migrating.

Also are there any tools through which we can use to test the performances of both the systems and compare.

I mean to load testing or something like that.

Please help.

Regards,

Vikas Madaan

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Vikas

The heterogeneous copy documentation does have all the information you will need to get started.

We have almost completed our migration of all our SAP instances from Oracle to MaxDB. For the performance comparison, I have only allocated the same memory to MaxDB as was allocated to Oracle 10g (SGA+PGA) and we have found the performance to be excellent so far. We will be migrating the Production ECC in December which is the big test.

To do load testing you will need a 3rd party product like LoadRunner. We didn't perform any load testing or benchmarking so I can't help you with figures there.

My only complaint with MaxDb is documentation. There is plenty of SAP Help style documentation but nothing concise yet. Christiane's book, SAP MaxDB Administration is not going to translated to English in the foreseeable future according to someone at SAP Press. Hopefully they will change their minds.

Regards

Doug

lbreddemann
Active Contributor
0 Kudos

> The heterogeneous copy documentation does have all the information you will need to get started.

Sounds good - unfortunately it's not true.

Many customers struggle with the migration.

> We have almost completed our migration of all our SAP instances from Oracle to MaxDB. For the performance comparison, I have only allocated the same memory to MaxDB as was allocated to Oracle 10g (SGA+PGA) and we have found the performance to be excellent so far. We will be migrating the Production ECC in December which is the big test.

Your production migration is your big test? Man, you either have guts or you cannot be fired...

> To do load testing you will need a 3rd party product like LoadRunner. We didn't perform any load testing or benchmarking so I can't help you with figures there.

Performance is one of the major concerns when doing a change of the DBMS platform with SAP.

In general the design of NetWeaver does all the DBMS abstraction - so technically the ABAP will work on either platform.

What it cannot do is tune the statements so that the performance will be optimal.

This is what the service is about.

Having seen quite some customers with production down performance issues after the migration (and without prior load testing) I cannot stress this point enough: get the service or a MaxDB tuning expert (good luck with that...).

> My only complaint with MaxDb is documentation. There is plenty of SAP Help style documentation but nothing concise yet. Christiane's book, SAP MaxDB Administration is not going to translated to English in the foreseeable future according to someone at SAP Press. Hopefully they will change their minds.

Have you tried the MaxDB documentation? [http://maxdb.sap.com/documentation].

There are chapters about Concepts and tutorials and stuff like this.

And there's more: check [http://maxdb.sap.com/training] and you'll get the MaxDB 7.6 internals course material for free.

Give it a try!

While we're at it: I guess you refer to the book Christiane announced (not: wrote) here

It's not written by her (although she has authored a book on SAP R/3 administration a long time ago...), but by two students of the technical university of munich.

And - if enough of you write to Galileo Press - I cannot think of a reason why this should not be translated.

> Doug

see you in your support message in december when you go live ...

regards,

Lars

markus_doehr2
Active Contributor
0 Kudos

> Performance is one of the major concerns when doing a change of the DBMS platform with SAP.

> In general the design of NetWeaver does all the DBMS abstraction - so technically the ABAP will work on either platform.

My impressions is: All new products (be it CRM, SRM or whatever is newer than software released after year 2000) works flawlessly.

When our MaxDB grew (actually almost 2.2 TB) we had performance issues in the (I call them) "legacy modules" (FI, AM, MM and CO) but 99 % of those problems were known and could be fixed quite easily by creating secondary indexes. I

> What it cannot do is tune the statements so that the performance will be optimal.

> This is what the service is about.

And I believe that exactly that experience (and more) is contained in the migration service. If we would do a migration nowadays I would book that service, you can avoid lots of known performance issues because the people doing that service know the database for a long time.

Just my EUR 0.02

Markus

lbreddemann
Active Contributor
0 Kudos

> We want to migate from Oracle to MaxDB.

Good decision!

> What are the possible test or procedures can do before migrating.

>

> Also are there any tools through which we can use to test the performances of both the systems and compare.

>

> I mean to load testing or something like that.

What you really should do is to order the Migration Service for MaxDB.

See this Wiki-page [MaxDB Migration Support Service|https://wiki.sdn.sap.com/wiki/x/dFo].

regards,

Lars