cancel
Showing results for 
Search instead for 
Did you mean: 

Resolution for Early Watch Alert--Wait statistics

Former Member
0 Kudos

Hi Everybody,

I have a production system on windows server 2000.

Database is sql server enterprise edition.

SAP 4.7.

I have got Early watch Alert on Wait statistics saying that

The average time for the following waitevent is high compared to our experience: WRITELOG

High wait times for WRITELOG indicate slow IO on the transaction log.

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).

I have already increased the size of transaction log.

Can any of you suggest some other solution to resolve this alert.

Thankx in advance

Regards

Abhishek

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Abhishek,

Could you please tell me what you did to solve this issue. I am also getting the same error in EWA on a new production system after fresh installation. I am using MS SQL server 2005 sp2 with 2 datafiles 60GB and one of 50GB and one logfile of size 100gb. Its for SAP NW2004s PI7 system.

Regards and thanks.

Edited by: Basis Consultant on Dec 1, 2008 11:43 AM

Former Member
0 Kudos

Hi,

Can have look into hardware level.

Refer these <b>987961 & 886337</b> also.

Reward points if helpful.

Regards,

Ganesh