|
Posted by Jack Vamvas on 03/17/06 18:52
If there are aren't anny errors and the query completes, there usually isn't
a problem.
Without knowing anything about your system, it usually points to the sql i/o
being greater then the disk system can maintain. In other words a request is
made and then retries until it gets a response.
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Marek Wierzbicki" <marek.wierzbickiiiii@azymuttttt.pl> wrote in message
news:dvep5t$1lot$1@news2.ipartners.pl...
> 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]
|