We have had issues for some time with MRP in that over the space of 2 weeks the time increases from around 5 to 6 hours up to 13/14/15 hours to run. We have to restart our server every 2 weeks to correct the issue.
I am thinking if i run a Trace on the locks when MRP is running it will identify any locks we may have when this is running which may help identify the issue however is there a list of tables anywhere that MRP uses when running as it may be that there are indexes that are all over the place on those tables.
Any Help would be appreciative.