|
|
Posted by Jack Vamvas on 06/14/06 12:15
Ideally you should maintain statistics on a daily basis . Are you relying on
AUTO UPDATE?
--
----
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Cray" <cray@nospam.o2.pl> wrote in message
news:e6nb6k$anb$1@inews.gazeta.pl...
> Hello,
>
>
>
> On the database we have stored procedure that loads couple thousands
> rows with information, it has to be done sequentially because during
> this load various variables and values has to be changed and modified.
> We have about 10000 rows to process every day - usually it takes about 1
> hour.
>
> Some time ago I have noticed a big decrease in performance of this
> process (it takes about 10 to 20 more time to process 10K), profiler
> showed me that duration of each read from some of the tables is huge and
> this is the reason why this process slows down. I have also a
> maintenance plan that updates statistics. When I run this job during
> processing usually everything goes back to normal and reads are very
> fast, performance is ok.
>
>
>
> Could someone explain why this is happening or give me a hint where I
> could find the explanation/answer.
>
>
>
> Greetings Cray
> ...........:::::::: [ @ ] ::::::::...........
> Cray at o2.pl
>
>
>
Navigation:
[Reply to this message]
|