MDM Performance

[Former Member]

Hi

We have a demo repository that we are running on my laptop.

We have created a batch that add 10000 records to the repository using the API.

On my laptop 1.7GHZ machine with 2MB MEM its working nice.

we have loaded it to a server 3.2G Xenon dual CPU with 3GB MEM. and now the MDM server is working very slow.

I can see that when i am running my batch code the CPU is on 1-5% only but on my laptop 100%.

Some one know what maybe the problem holding the MDM server to run 100% of the CPUs?

Thanks

Noam

[Former Member]

Hi,

Based on my experience, usually the oracle database will help you achive a better performance when managing big volumens of information and transaction. One of the reasons is that in Oracle you can configure a big set of parameters and in sql you have to stick to what sql natural optimizer can do.

It is also interesting to mention that because of the mdm nature (that is to sinch a lot of information from a lot of systems, being sinchronize often the same time), you need to asure that readers dont block writers and viceversa. In sql server there are block locking issues and something called locks scalation that kill performance. Oracle concurrency model is very good handling this so that readers dont block writers and viceversa.

Hope it helps.

[Former Member]

hi,

As far as my knowledge goes there is no separate

repository for IT scenarios, GDS and catalog publishing. GDS stores the trade item data in MDM repository iteself.

Though GDS is an application built upon MDM platform and uses hence its repository this repository can not be used for other purposes than GDS. In other words, this is a private GDS repository and if you want to leverage product data for other purposes you have to build another MDM repository.

In regards to IT scenarios it actually depends on your business scenarios. It may be one repository used for harmonization and central data management or two different. Anyway it's one repository per object family (Customers, Products, Employees and so on

hope it helps. Assign points if its useful.

thanks

Varun CN

[Former Member]

Hi All the problem has been solved

It seems that it was an IT issue related to SCASI DB Cache.

we have enabled the "Enable Advance Performance" in the HD hardware settings and now it working fine.

Thanks all for your help

Noam

[Former Member]

deleted

Message was edited by: Marina Sinichenko

[Former Member]

Marina,

Ya vypusknik Baumanskoy Sdushor v Moskve i shkoly #310 (1993). Yesli vy uchilis' v etoy shkole (volleybol'niy klass), pozhaluysta napishite mne po adresu ilyaumanskiy@optonline.net

Vsego khoroshego.

[Former Member]

Hi,

How many qualified tables are there in the repository?

Are you adding the qualified table records thu the batch process ?

What database you are using?

These are my observations from my previous projects.

1.More No of qualified tables import will decrease the performance.

2.Oracle is slow when compared to SQL Server. Even more slow when Database,MDM Server and Import Batch Process are in different machines.

Network connection also might be one of the root cause.

Thanks and Regards

Subbu

[Former Member]

Hi Subbu

Its SQL 2000. the problem is that its working fine on my laptop. when moving it to the server its working very slow it looks that the MDM server is working very very slow like something is holding him back.

Thanks

Noam

[Former Member]

Hi,

Just check which process is taking more memory usage from the Task Manager. Is it only the batch process utilizing the more memory usage are there are any other process which is also taking more memoru usage

Thanks and Regards

Subbu