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