ST04 with Wait Time per Log Write (ms) exceeds 10 milliseconds

[Former Member]

Hi Gurus,

recently i have upgraded from ECC 6.0 to EHP5 database is SQL Server 2005

after upgrade my database size increased more specially transaction log.

before upgrade database data files are 30, 30, 30 gb and transaction log is also 30 gb.

due to space issue i had shrink database, after shrink i facing below error on ST04, DB02 transaction.

Wait Time per Log Write (ms) exceeds 10 milliseconds

Check the I/O performance of the database server

am not able to find any notes on this.

for database ST04, DB02 screens please find attachments.

Thanks in advance,

Venkat

[JPReyes]

I/O could be affected by a lot of things... are your disks local?... Are they sharing physical disks?

Also read

Note 879941 - Configuration Parameters for SQL Server 2005

Regards, Juan

[Former Member]

Hi Juan,

Thanks for your reply.

my disks are local.

already i have gone through Note which you have provided and looks like all recommended settings are set.

before upgrade i never see this kind errors/warnings

Thanks,

Venkat

[JPReyes]

I can see that they are all sharing the same drive, I think you should try to move the Log file into a different disk at least.

Regards, Juan

[Former Member]

Hi Juan,

even before upgrade also all are in same drive only.

i have doubt on transaction log size, shall i increase its size? will it help me?

Thanks,

Venkat

[JPReyes]

Transaction log size shouldn't affect the write speed to it..

Check ST06 -> Detailed Analysis Menu -> Disk

Regards, Juan

[former_member189725]

Check the disk with highest response time in ST06 and check if that holds the transaction log .

Refer the SAP note Note 987961 - FAQ: SQL Server I/O performance

Regards

Ratnajit