performance problem dev_io slowed

[Former Member]

Hi all,

I am using MAXDB on a ERP system. This worked fine but a few days ago the access to the files went bad.

The answer from my colleagues is "nobody did nothing" so what could influence the read and write time to the database files?

Read time is above 150 ms for all files. Which files could I check on Linux to figure out the problem?

Thanks.

Best regards

Christian

[former_member188883 · Accepted solution]

Hi Christian,

Refer link http://wiki.sdn.sap.com/wiki/display/MaxDB/TuningSAPMaxDB

This has very good information on tuning your MaxDB database for optimal performance.

To understand performance and response o Linux you can Os level command

sar 2 20 => This will give you utilization of server every 2 mins for 20 iterations

top command will give you details of memory utilization and paging information on the server.

Regards,

Deepak Kori