It's all about the answers!

Ask a question

What happens at 3AM?

Sean F (1.3k249160) | asked Apr 02 '21, 12:19 p.m.

My standalone 702 server always jumps to life at 3AM and the processor starts thrashing for over an hour and the server becomes difficult to use.

I checked the schedule for DW and all the DW jobs are scheduled to run at 00.00 so it is not DW I don't think.

is there some other scheduled database activity that kicks off at 3AM and can it be changed to a different time?

Accepted answer

permanent link
Davyd Norris (2.4k217) | answered Apr 03 '21, 9:59 p.m.
Normally the DW has two sets of jobs - the core ones at the top run at midnight and the more intensive ones run at 3 from memory.

Check the schedule for the second set of jobs and see if that's it
Sean F selected this answer as the correct answer

One other answer

permanent link
Carol Watson (71017) | answered Apr 02 '21, 12:29 p.m.

 Hi Sean,

We're on, so not sure this applies, but we run this task nightly during the early hours (see RM Advanced Properties)..  Could it be something like that?


Sean F commented Apr 02 '21, 2:33 p.m.
Thanks Carol

That is disabled on my server value = -1

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.