Process MRP Failing

[dr_dan (Dan Ramirez)]

Another good question would be why does deleting the TFOrdDtl table take close to an hour. I found this in the archives. It’s over my head, though. @tkueppers maybe you can make sense of it?

MRP Trouble

Over the weekend the evil MRP crashing after an hour of trying to “delete unfirm jobs” returned with no solution in sight. So I spoke with my cousin who knows a thing or two about SQL databases as well, and he reminded me of the awesome power of being able to look at the currently running queries using a sproc like sp_WhoIsActive2 or my-favorite-query. So I kicked off MRP Full Regen, let it get to the Deleting Unfirm Jobs step, waited a few minutes, and then ran sp_WhoIsActive2 - and there wa…