Posted by Marek Wierzbicki on 03/17/06 18:46

Hi

In my server (MSSQL 2000 sp4) very often I see long time of executing query
with waittype=WRITELOG

Recovery is set to SIMPLE and there is no autoShrink.

Auto increment file size (log) is set to 10%

What can be the reason of this problem?

Marek

[Back to original message]