• Did you tried using table hints on the tables? and what is MAXDOP value now?