Posted by Erland Sommarskog on 03/21/06 00:28

Marek Wierzbicki (marek.wierzbickiiiii@azymuttttt.pl) writes:
>>> 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?
>
>
> I am looking for reason slowly works of my SQL

WRITELOG may have something to do with it, but it may also be a false
clue.

Since I don't know your system, I cannot give much direct advice. But
I would suggest to start to scrutinize queries and indexes,.


--
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]