|
Posted by Marek Wierzbicki on 03/20/06 14:27
>> 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
Marek
Navigation:
[Reply to this message]
|