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
Navigation:
[Reply to this message]
|