Performance issue of BI system

[Ashwini_khemka]

Hi ,

In our production server we have scheduled UPDATE STATATICS (in db13) to run at 05:00am daily.

The user is also extracting the data load on the same time which cause performance on the system and user saying that time consuming by data extraction taking long time . Can you please let me know what should to be done so that UPDATE statistics will run and data extraction will also without effecting the system performance and delay of data extraction in BI system (should not took long time).

Regards

Brijesh

[Former Member]

Just pre/postpone the Update statistics job, Re-schedule it with new timings.

Regards,

Nick Loy

[Ashwini_khemka]

Hi ,

I have change the time for the UPDATE STATISTICS from 5am to 3am (the new time is 3am , previously it was 5am).

But seems no result , the issue is same.

Please let me know some solution for this

Regards

Brijesh Prasad

[Former Member]

Find out when the update statistics job ended.

You may have to start it even earlier.

Or you will find out that the user's problem is not related to that job.