cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

DCRUM12.4.12 Daily report generation running more than 3 hours, how do I find out the cause of this?

aubrey_conner
Participant
 
2 REPLIES 2

BabarQayyum
Leader

Hello Aubrey,

The daily report generation has multiple tasks to do and it especially depends on the size of database (if I am not wrong the recommended size 300 GB with in enterprise environment).

Below two tasks are an example of among others:

  1. Shrinks tmpdb and its transaction log
  2. Shrinks database transaction log file

Our DB size is 450GB+ and daily report generation task is taking near about 3 and a half hours.

If your task is failing then you can extend the time as you can see in the above screenshot that timed out is configure for 10 hours.

Regards,

Babar

aubrey_conner
Participant

Hi Babar,

Thanks for this insight, I think this points me in the right direction.

Aubrey