Write Log Errors

58 Views

Hi All,

We have a SAP 4.7/windows 2000 server/SQL Server 2000.

We are getting error in Early Watch report

<b>WRITELOG 13654257 1047443 13,04 6,00 </b>

Recommendation from SAP:

The table above shows very high wait times for wait type(s) PAGEIOLATCH_SH (above 20ms for each I/O) and/or WRITELOG (above 10ms for each I/O). These figures have been calculated from data recorded since your last database reboot. We therefore recommend that you observe these values over a longer period of time. If you do not notice an improvement, this indicates a severe performance problem (see SAP Note 521750).

Recommendation:

Use a transaction log of sufficient size so that no growth occurs. Also check the I/O subsystem for possible improvements.

We have increased the log size but the problem persists.

Can you suggest what more can be done and also how to check PAGEIOLATCH_SH & WRITELOG

Regards

Abhishek