Posted by Erland Sommarskog on 03/18/06 00:32

Marek Wierzbicki (marek.wierzbickiiiii@azymuttttt.pl) writes:
> 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?

On my machine at home I see six processes with *last*waittype = WRITELOG.
All are system spids.

As far as I know you can see the current wait type in clear text anyway,
but there is a binary column waittype in sysprocesses.

This long-running query, is it performing any updates?

And most importantly, do you perceive any real performance problems?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]