• have you updated statistics and or see any differences in execution plans compared to prod. Like compare the tasks in the execution plans with prod's.

    also maybe prod has buffer cache and nonprod has no plan cache if it was recently restarted or restored new db. my guess