MDM performance test

[Former Member]

Hi all,

Anyone has done a performance test on MDM? Any test script would be really helpful!

Thanks in advance.

[Former Member]

Hi,

MDM Performance need to be monitored in basically two main MDM activities when it come to working in MDM real time:

1) MDM Importing

2) MDM Syndicatiion

MDM Importing:

- When ever you are using MDM in an IT Landscape there will be many source systems from where data will be inputted into MDM.

- This data may either be imported in a Manual fashion or Automatically as in most case using the MDM import server.

- In either case you will have to deal with thousands of records.

- Importing such a large set of records afftects the performance as very stage till importing means(at the record matching steps etc till teh final import)

- The performance gets affected slowing the process of importing right from opening a saved map ar even Field or value mapping.

- And above all if you have an exception due to which a single record in the import chunk fails then the entire set fails.

- So care must be taken to improve the performance of importing records.

- Which is done taking into consideration the following:

Areas to focus on improving performance during Importing:

1) The chunk size which defines the number of records to be imported at a time

2) The number of records processed parallely (MDIS settings)

3) The number of Fields Mapped

4) Number of Matching field used

5) The number of Validations and assignemnts running on the records etc

MDM Syndication:

- In the similar lines MDM performance also should be monitored when Harmonising data to the target systems

- Selecting the records to be syndicated using search criteria,Suppressing Unchanged records,Key mapping etc all afftects the MDM performance adversely.

You can in general create test scripts that will monitor MDM system performance in thes two prime areas as well as in MDM generak activities as well.Using different OS and different sizing.As MDM performance will differ according to the Software used in each case which includes the disk space,Cache and RAM as well.

You can Create test scripts on the following activities using differnt Configurations and thus compare and test teh performance of teh MDM system under different conditions with the expected output as against the actual output

- Testing mounting/unmounting repoisitory

- Loading/Unloading Rep

- Export/Import Schema

- Archieving/Unarchieving rep

- Creating Master/Slave rep

- Importing different sets of Records using manual and automatic method

- Syndicating different sets of rec using Manual and automatic method

Hope it helped

Thanks & Regards

Simona Pinto

[former_member182007]

Hi,

In MDM 5.5 SP05 patch2 improve the perforamance but still there is you need to do enhancement like nested qualified tabel. we need to standered message type for classification data.

There has been an improvement in the MDM5.5 SP05 in patch 2 as compare to SP04.

1. With SP04, it used to take couple of hours to add and delete fields. ( Bad response times within Portal UI).

But With SP05 it hardly takes 15 secs.

Landscape changes-

In SP04, Portal and MDM server was divided into 2 machines and a new database was installed on the local MDM server.

Reasons for better performances:

1. Upgrade to MDM5.5 SP05

2. Extra hardware ( previously MDM was installed with Portal on 1 box).

3.Newly installed Database software .No fragments.

Hope it helps.

Rgds

Deepak

[Former Member]

Hi,

Please go through the below links:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60aacf9a-84c2-2a10-ae81-c2f52f0a...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60ec1de2-76c6-2a10-7198-fa4e9dd0...

Regards,

Jitesh Talreja

[Former Member]

Hi ,

What is the purpose o fhte test ?

Are u going for new support pack or want to check it for some business scenario.

Anand K