• @vultar

    Was the proc in live taking 7 mins repeatedly or was it just the one occurrence ?

    -- it was taking repeatedly more than 7mins to execute and application is timing out with error.

    Did you look at the actual execution plans from the procs in live & test.. We're there any differences ?

    -- Both the execution plans looks exactly same.