markus.metzger@benteler.com asked a question.
DUJ: Long runtime on dbo.JobRefreshAlerts
Hi all
since release change to #SLM 9 we see that this jobstep takes long time in the DUJ processing.
Snow Support is more or less no help.
It is suggested to disable "#auto indexing" on MS SQL, but when we ask on which table, we should get consulting service on that. We know that tblAlerts is the table which causes the problem.
So I post the question in this forum:
The following indexes are currently defined in our database:
- IX_tblAlerts_CID_UserID
- PK_tblAlerts
It this the setting which you also have and your runtimes are ok / not ok (>1h)?
Thank you for helping!
Best regards
Markus Metzger
We see a similar issue , this specific job takes +5h to run every day.
Any way we can troubleshoot this ?
@Bart Vanlessen​
Hi Bart
my daily DUJ takes 45 - 50 minutes (SLM 9.12). The weekend job incl. reset of ruleset takes 16 h.
14.000 clients.
You should check which step is so time-consuming (tblJobLog).
I recommend to open a ticket at SNOW Support. They will give you more recommendations.
Thanks , that gives a nice indication of what it should be.
Hi Markus, Bart,
We have the same issue: SLM 9.12, daily DUJ takes 8 - 10h, JobRefreshAlerts takes 5,5h of it. Largest tenant 15k clients.
Is there a solution already?
As far as I can read, this was a problem with 8.2 also. But we are struggling already long time with this...
Thanks for idea's or help!
A nice post here in the community might help?
https://community.flexera.com/s/article/DUJ-JobInventoryGetInventoryData-and-dbo-JobRefreshAlerts-never-completes
Hi Markus,
Sincere apologies for the late reply, and I do hope that this is no longer an issue in your environment. Please let me know if you need any further assistance on the matter.
Kind regards,
...Stefan