Compare performance of two different databases...idea of a report to us?

[alexander_tuerk2]

Dear Colleagues,

We would like to compare the performance of two different databases running with SAP. We don't want to start with Loadrunner. We are looking more for some ABAP program which generates a lot of load on the database and then would just run the program on both databases. Any idea for a good report? We thought about sgen, but we think this is taking more into account the application server instead of the database.

Regards,

alexander

[ACE-SAP · Accepted solution]

Hello,

If you are not willing to use tools like HP Loadrunner or IBM Rational performance testing

SGEN could be an option. It is quite intensively using the DB. It will be hard to find a report that only perform DB access.

SGEN at least allows to test read (REPOSRC, DYNPSOURCE...) & write (REPOLOAD, DYNPLOAD...). If the DBs are on the same servers as the SAP system and both servers has the same power it can be a good way to test.

Best regards