cancel
Showing results for 
Search instead for 
Did you mean: 

Performance issue of BI system

Ashwini_khemka
Explorer
0 Kudos
80

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Regards,

Nick Loy

Ashwini_khemka
Explorer
0 Kudos

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
0 Kudos

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.